Post reply

Back and restore

  • June 22, 2007 at 9:45 am

    #70567

    SQL version 2k

    After creating a full backup file and then appending incrementals to it, one of the incrementals fail in the middle of execution. Is the backup file still good? or has this failure corrupted the entire backup file?

    Thanks in advance for any help on this...

  • June 22, 2007 at 9:50 am

    #714629

    You can try a RESTORE VERIFYONLY on the file, but I would suggest restoring the full and incrementals on a test server as this would be the best way to know for sure.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 22, 2007 at 10:10 am

    #714635

    Thanks for your reply, and yes, that would verify this one, but I have many Db backups and from time to time there will be a failure. What I would like to know is when a failure accures as mensioned above: (1) the backup is bad (2) the backup is fine (3) unknow without testing.

     

  • June 22, 2007 at 10:17 am

    #714639

    It would be great if you knew for sure that it was a good or bad backup; however, all backups would fall into your #3 category.  One never truely knows the validity of a backup witout attempting a restore.  I would recommend periodically testing your backup files by restoring as this is the only way to ever know for sure that your backups are good.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 24, 2007 at 11:17 pm

    #714850

    You can verify the the integrity of the database backup once the backup is complete. This can be done with choosing verify the intgrity of backup after completion if done through enterprise manager or using restore verifyonly with tsql.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply