HOW WILL YOU VERIFY THAT A BACKUP SET IS VALID WITHOUT RETORING IT??

In Database, Backups are the starting point for any serious disaster recovery strategy. Taking SQL database backups on a regular basis is just the first step of recovery. It is also important to make sure that they are reliable and restorable. This is the only way to avoid unpleasant surprises in case of a disaster.

We can check the validation of a database backups without restring it. So, Let see how to do the same.

I have a backup file "Test.Bak" of test database which is available at below location:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup

To see the that this backup set is usable or not we will have to execute the below T-SQL code:

RESTORE VERIFYONLY FROM 

DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\TEST.BAK'

So, this is how we can validate the Backup set.

Thanks For Reading this Post!!!