New Pluralsight course: Understanding and Performing Backups

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description:

It’s really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means it’s critical that you understand what backups are and how to create them. In this course, SQL Server: Understanding and Performing Backups, you’ll learn what SQL Server backups are, why they’re required, and how they work. First, you’ll explore how to formulate a backup strategy based on business requirements and what restores you may need to perform. Next, you’ll delve into commonly used backup options. Finally, you’ll discover how to use backup compression, backup encryption, and maintain backup integrity. When you’re finished with this course, you’ll have the skills and knowledge to confidently perform backups in your environment and create a backup strategy.

The modules are:

  • Introduction
  • Full and Differential Data Backups
  • Transaction Log Backups
  • Log Backup Options and Considerations
  • Backup Strategies
  • General Backup Options
  • Backup Compression, Encryption, and Integrity

Check it out here.

We now have more than 165 hours of SQLskills online training available (see all our 56 courses here), all for as little as $29/month through Pluralsight (including more than 6,000 other developer and IT training courses). That’s unbeatable value that you can’t afford to ignore.

Enjoy!

6 thoughts on “New Pluralsight course: Understanding and Performing Backups

  1. we can’t restore all t-logs backups between differential backups as log backup chain interrupted by ad-hoc full backup, isn’t it?

    in course
    SQL Server: Understanding and Performing Backups

    7) General Backup Options
    COPY_ONLY Backups
    @ 2:42 / 2:46

  2. In the scenario below:

    backup database dbname filegroup = ‘Primary’ to disk = ‘D:\Backup\Primary.bak’
    go

    backup database dbname filegroup = ‘Sales’ to disk = ‘D:\Backup\Sales.bak’
    go

    On another server:
    Restore database dbname filegroup = ‘Primary’ from disk = ‘D:\Backup\Primary.bak’
    Restore successful !
    But :

    Restore database dbname filegroup = ‘Sales’ from disk = ‘D:\Backup\Sales.bak’
    Error:
    The supplied backup is not on the same recovery path as the database, and is ineligible for use for an online file restore!

    What is the cause of this problem?

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.