November 12, 2006 at 8:11 pm
I have a job which reindexes some really large tables. I was expecting the reindexing to complete before the start of business day, but it seems like it is going to take longer.
The job reindexes 5 tables and is currently running the reindex on the 2nd table.
If I cancel the job, before the end of table 2 or after the 3rd table starts re-indexing, to what point will the job rollback?
The reindex first drops all indexes and then re-created them...would the rollback be to a point before the drop or after the drop?
Any ideas or suggestions?
November 13, 2006 at 3:39 am
It'll rollback whatever it's currently doing. Always test, Always test, Always test !!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply