Cancelling an indexing process

#1

This came up in a recent conversation.

What happens if I reboot the computer while a reindexing process in
underway?

a. Acceptable
b. Not a best practice
c. Suicide

Any feedback is greatly appreciated :-)

Saga

#2

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

Quote:

This came up in a recent conversation.

What happens if I reboot the computer while a reindexing process in
underway?

a. Acceptable
b. Not a best practice
c. Suicide

Any feedback is greatly appreciated :-)

Saga

#3

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>
wrote:

Quote:

This came up in a recent conversation.

What happens if I reboot the computer while a reindexing process in
underway?

a. Acceptable
b. Not a best practice
c. Suicide

Any feedback is greatly appreciated :-)

Saga

#4

Thank you both :-)
Saga

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cancelling an indexing process

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Cancelling an indexing process - 03-31-2006 , 04:24 PM

Re: Cancelling an indexing process - 03-31-2006 , 07:42 PM

Re: Cancelling an indexing process - 04-01-2006 , 06:37 PM

Re: Cancelling an indexing process - 04-03-2006 , 10:32 AM