SQL SERVER – Check Backup Reliability

Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability. Well, honestly, yes there is a way and that is to restore the backup on your database.

Check Backup Reliability

Lots of people often ask me if there is a way to figure out if the backup of the database is fine or not. Honestly, there is no magic trick or there is no shortcut for it. You will have to restore your database on your production server or on the development server and see if the data is valid or not.

There is honestly no other shortcut. I have seen so many organizations who think that their backup is valid and good but when they try to restore it, it fails.

Here are my few recent videos and I would like to know what is your feedback about them. You can subscribe to my youtube channel here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Backup, SQL Restore, SQL Scripts, SQL Server
Previous Post
SQL SERVER – Who Dropped Table? Part 2
Next Post
MySQL MariaDB – Query Using Temp Table

Related Posts

1 Comment. Leave new

  • Restoring database just to check if backup is valid may be not enough. DBCC CHECKDB may reveal corruption in database restored from correct backup. Been there, seen that :)
    Also, checking backup: should it be done on licensed instance?

    Reply

Leave a Reply

Menu
Exit mobile version