Validating Database Backup file

Validating the backup file whether accessible/restorable/actual space needed for restoring the backup.

Basically, The script reads and returns Data and Log information from the Backup file.

Use Master
Restore FileListOnly From Disk='D:\Backup\SQLServerBuddy_20100722.Bak'

Whenever we take a database backup it should be validated either the backup file is Restorable/accessible/Not.

The statement returns two rows for data and log file with actual size without any Err, So, the backup file is valid, accessible and restorable.

If the statement returns any Err other than the Data and Log file information then, we should go for some other backup.

Backup file should be there in local system/server where we using the script given above.

No comments:

Post a Comment