Post reply

Stopping DBCC Reindex

  • July 15, 2005 at 10:02 am

    #167886

    Does stopping of DBCC Reindex corrupts the db?

    Thanks!

  • July 15, 2005 at 11:22 am

    #574969

    It should not. I have done this and I think it's a transaction, so it undoes the work done. Or maybe it just stops, can't remember.

  • July 15, 2005 at 12:33 pm

    #574998

    Thanks Steve!  Yes we tried testing it on our test server and it didn't corrupt the DB so you're right on that.

    Thanks again...

  • July 18, 2005 at 3:10 pm

    #575337

    It runs in one big transaction.  If you stop it then it will roll back, which can be a pain, as I found out earlier today.  indexdefrag works in smaller increments, though it can fill up the tran log.

     

    Dylan

    Dylan Peters
    SQL Server DBA

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

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