May 21, 2012 at 1:13 pm
Hello Masters,
Is there any check through which we can verify Backup file? I mean to say after any backup how can we check that the backup file is not corrupted and consistent ? Any query or command ?
May 21, 2012 at 1:31 pm
Best way, restore it to test, dev or sandbox server. Anything else could just give you a false sense of security.
May 22, 2012 at 4:18 am
The only way to be 100% sure is to restore the database. I wrote this short article [/url]laying out the various things you can do and what they do for you. It should get you started.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 23, 2012 at 8:30 am
I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking for a way to make an automatic verification process I would check out the RESTORE VERIFYONLY statement in BOL. It may not be perfect but it may suit your needs.
May 23, 2012 at 8:50 am
ken.willekens (5/23/2012)
I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking for a way to make an automatic verification process I would check out the RESTORE VERIFYONLY statement in BOL. It may not be perfect but it may suit your needs.
Just remember that passing the RESTORE VERIFYONLY doesn't guarantee that you will be able to restore the database from this backup file.
May 24, 2012 at 10:56 am
Its already been said but actually restoring is the best way, however, you can also use
RESTORE HEADERONLY
RESTORE FILELISTONLY
If you can read the filelist and header details there's an extremely good chance your backup is sound.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2012 at 6:20 am
Lynn Pettis (5/23/2012)
ken.willekens (5/23/2012)
I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking for a way to make an automatic verification process I would check out the RESTORE VERIFYONLY statement in BOL. It may not be perfect but it may suit your needs.Just remember that passing the RESTORE VERIFYONLY doesn't guarantee that you will be able to restore the database from this backup file.
+1
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply