October 29, 2009 at 11:33 pm
Hi
suppose i am reindexing a large table using dbcc dbreindex or alter index statment in sql 2005 ent edition or any sql server for that matter.
I for some reason such as large log files , low disk space or locks etc decide to stop the reindexing what impact can it happen on the integrity of the database or the table data on which i was ding the reidexing.
will it harm the data in any way espeically if it is a clustered index ??
thanks
October 30, 2009 at 3:21 am
If stopped, dbcc reindex will rollback - ie it will use the t logs to undo all the work carried out to that point, meaning your index will still be fragmented, but will still be there.
October 30, 2009 at 6:44 pm
No harm will be done, but the table/index will (continue to) be blocked while the rollback occurs, which can take pretty much as long as the work to that point took.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply