March 2, 2012 at 4:03 am
Hi I have backup the database files as its very critical data we need to have backup verify.
Can any one let me know is there any way to verify the backup file so that it can be restore later.
March 2, 2012 at 4:10 am
take a look at this link http://msdn.microsoft.com/en-us/library/ms188902.aspx, should give you what you need
March 2, 2012 at 4:14 am
Backup WITH CHECKSUMS can make the backup file itself more reliable - http://msdn.microsoft.com/en-us/library/ms189587.aspx.
However, the best way to check backups are ok is to restore the data elsewhere and run DBCC on the restored database.
Edited for typo.
March 2, 2012 at 4:17 am
May I recommend Advanced Backup and Restore Options by Paul Randal?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply