Post reply

Rollback or committed

  • July 31, 2011 at 12:37 pm

    #242357

    I had maintenance plan which will Check DB Integrity,rebuild indexes weekly. If it fails after an hour of execution, all the operations performed within that hour will be committed or rollback?

    Its SQL Server 2008R2

  • July 31, 2011 at 1:34 pm

    #1361325

    Depends. Unless the whole lot are run in a transaction (unlikely and probably silly) any statements that finished would have committed any that hadn't finished would rollback.

    CheckDB doesn't rollback because it doesn't make any changes.

    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 2 posts - 1 through 1 (of 1 total)

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