Post reply

Check Backup

  • November 17, 2008 at 1:46 pm

    #124315

    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

    #899544

    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

    #899549

    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

    #899644

    check the verify option while taking the backup..

  • November 18, 2008 at 5:46 am

    #899837

    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