Post reply

Can it be fesiable to Take the Backup on one server and verify on another one.

  • June 11, 2008 at 10:01 pm

    #122601

    Hi,

    I am facing the problem when i am taking the backup and verify it .It makes my server busy

    Is there any option so that i can move my backup to another server and verify for the same

    and howmuch it is fesiable.

    Thanks in Advance

  • June 12, 2008 at 3:12 am

    #827707

    Yes you can copy the backup file to another server and verify them using the following command,

    Restore verifyonly from disk='Path\filename.bak'

    [font="Verdana"]- Deepak[/font]

  • June 13, 2008 at 12:54 am

    #828278

    I've always restored the database and ran checkdb, then open a table ot two.

    The verifyonly performs minimal checks - if you have the time and space I'd use the above method

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

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