Stop SQL Server 2005 Recovery Index

Question

Can I stop the reorganization of SQL Server and rebuild the index task while it is still ongoing?

thanks

Answer 1

Yes, you can. Recovery will be a rollback, and the index will be in the exact state it was in before the rebuilding began. The record (aka defragmentation) will stop where it is, and start backing up where it stopped (or at least close) the next time you start.

In fact, I have a job that looks to see if my service job is working and stops it if it is 5 in the morning.

Answer 2

SQL, SPID, rebuild. , .