Kill DBCC Reindex?

[Mitch]

Can anyone explain what happens if you kill a dbcc
reindex command (all indexes)?

[Jacco Schalkwijk]

DBCC DBREINDEX is one transaction, and when you kill a process, the
transactions that it is running will be rolled back. So you will end up with
the same situation you had before you ran DBCC DBREINDEX, and you will
probably have to wait quite a long time (maybe the same time as DBCC
DBREINDEX has run already) for the rollback to complete.

[a***@discussions.microsoft.com]

So if the process was blocking users to access a
database, and you killed the process, it just returns the
indexes back to their original form? Doesn't damage the
indexes?

-----Original Message-----
DBCC DBREINDEX is one transaction, and when you kill a

process, the

transactions that it is running will be rolled back. So

you will end up with

the same situation you had before you ran DBCC

DBREINDEX, and you will

probably have to wait quite a long time (maybe the same

time as DBCC

DBREINDEX has run already) for the rollback to complete.
--
Jacco Schalkwijk
SQL Server MVP

Post by Mitch
Can anyone explain what happens if you kill a dbcc
reindex command (all indexes)?

.

[Jacco Schalkwijk]

It will return the indexes to what they were before. Your users can't access
the table though while the rollback is in progress.
--
Jacco Schalkwijk
SQL Server MVP

Post by a***@discussions.microsoft.com
So if the process was blocking users to access a
database, and you killed the process, it just returns the
indexes back to their original form? Doesn't damage the
indexes?

-----Original Message-----
DBCC DBREINDEX is one transaction, and when you kill a

process, the

transactions that it is running will be rolled back. So

you will end up with

the same situation you had before you ran DBCC

DBREINDEX, and you will

probably have to wait quite a long time (maybe the same

time as DBCC

DBREINDEX has run already) for the rollback to complete.
--
Jacco Schalkwijk
SQL Server MVP

Post by Mitch
Can anyone explain what happens if you kill a dbcc
reindex command (all indexes)?

.