Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crossRacer
Starting Member
1 Post |
 Posted - 2009-10-03 : 00:34:37
|
| Hi all, I am attempting to run dbcc indexdefrag on some very large indexes. I chose this option because I read it could be stopped and restarted without losing work. I could not find the appropriate way to stop and restart so I ran it in em and just clicked stop, then reran.Unfortunately when I stopped, the last message I saw was "DBCC: Compaction phase of index 'IX_Message_Links' is 40% complete." when I restrarted I got "DBCC: Compaction phase of index 'IX_Message_Links' is 5% complete."Has it started over? Is there a way to tell?Thanks in advance!! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-03 : 14:45:23
|
| It has started over but since indexdefrag just moves pages that are out of order it will go fast over the section it did before and then carry on from there.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
How to stop/Restart dbcc indexDefrag ?