Post reply

Restore Help

  • June 15, 2011 at 12:49 am

    #148124

    We had a Situation where the 5 hrs Restore got stopped due to network issue. Is there a way where i can re start the restore from the time where it got dropped or i have to re run the restore back from the start.

    Sandeep.

  • June 15, 2011 at 2:42 am

    #1338811

    Try the RESTART keyword on the RESTORE.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 15, 2011 at 3:25 am

    #1338833

    BOL refers that: RESTORE can be restarted after an error. In addition, you can instruct RESTORE to continue despite errors, and it restores as much data as possible (see the CONTINUE_AFTER_ERROR option).

    -Satya SK Jayanty
    SQL Server MVP (Follow me @sqlmaster)
    Author of SQL Server 2008 R2 Administration CookBook
    SQL Server Knowledge Sharing network

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

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