Cancelling an indexing process - 03-31-2006 , 04:24 PM
This came up in a recent conversation.
What happens if I reboot the computer while a reindexing process in
b. Not a best practice
Any feedback is greatly appreciated :-)
Re: Cancelling an indexing process - 03-31-2006 , 07:42 PM
Any work that was in process will need to be rolled back. This is not a
wise thing to do on purpose but it should handle it OK but may take a while
to roll back everything when it comes back up.
Andrew J. Kelly SQL MVP
"Saga" <antiSpam (AT) somewhere (DOT) com> wrote
Re: Cancelling an indexing process - 04-01-2006 , 06:37 PM
All transactions involved with the reindexing will begin rolling back
after the reboot. Count on the restore taking 2-3 times as long as teh
indexing operation had been going on.
On Fri, 31 Mar 2006 15:24:53 -0600, "Saga" <antiSpam (AT) somewhere (DOT) com>