Post reply

Cancelling a DB thats restoring

  • May 23, 2012 at 3:47 am

    #261253

    Hi all

    What happens to a DB if you cancelled the restore for a DB thats been set to overwrite existing. How does the rollback work? Will the DB contain only partial data?

    Thanks

  • May 23, 2012 at 3:54 am

    #1491643

    Not sure the state of the database when the "cancel" was requested and how it "cancelled" - the best advice would be to do a restore prior to the aborted restore.

    ( Just my opinion )

    Regards

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • May 23, 2012 at 3:58 am

    #1491644

    The remaining database will be marked as in the middle of a restore and will be unusable. You'd have to restart the restore and complete it to access the database.

    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

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

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