November 17, 2008 at 1:46 pm
Is there a way where i can check if my back up file is good. Every time I take a backup i doubt if my backup file will work fine when i plan to restore. I would like to verify my bak up file after every bak up.
November 17, 2008 at 1:50 pm
If you have the space available on your server, you could restore it to a test database (using a different name, of course), being sure to move where the physical files will be restored (either a different directory, or files names, or both).
This could be scripted to be a part of your backup process.
November 17, 2008 at 1:57 pm
Hi Mike,
You can use RESTORE VERIFYONLY to check for the backup.
See this page fore more info http://technet.microsoft.com/en-us/library/ms188902(SQL.90).aspx
Otherwise you will have to do a restore to be sure.
gr,
Chris
November 17, 2008 at 5:39 pm
check the verify option while taking the backup..
November 18, 2008 at 5:46 am
AS said Verify option verifies the file, for your peace of mind and as best practice, you can restore the databases on a test server on regular intervals 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply