December 22, 2003 at 9:52 am
We have a fairly large database with a couple of big tables in them (80M rows). We made the mistake of using a guid to join these and decided to swap to an integer. The process to do this was running for about 6 day when the trans log filled and the server sell over and windows rebooted itself.
Now we have a database that is in recovery mode. Is there any way to speed this up or cancell it and with what effect? What would happen if I restore the backup from last night and restart the db. Would it roll back for a few days or continue to try and update the table?
Thanks,
Tim..
December 22, 2003 at 10:02 am
it should be rolling back the transaction and you will have to wait until it completes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply