Post reply

Backup & restore

  • June 2, 2010 at 12:41 am

    #223218

    HI all, i have taken a full backup of my sql server 2008 backup and it was done successfully,

    My question is how to validate that my backup file is perfect or not ?

    can anybody assist regarding this. and also refer good books for backup and restore

  • June 2, 2010 at 1:00 am

    #1175120

    i got it from another form .

    ITs RESTORE VERIFYONLY options with checksum i can validate the backup files

  • June 2, 2010 at 1:28 am

    #1175124

    RESTORE VERIFYONLY will detect most of the errors but not all of them. It is a good idea to restore your backups frequently to check their validity.

  • June 8, 2010 at 1:23 pm

    #1177650

    I agree with Gaurav.

    "RESTORE VERIFYONLY options with checksum " is useful but to check integrity of backup you need to validate by restoring it(in test server)

Viewing 4 posts - 1 through 3 (of 3 total)

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