September 27, 2005 at 11:24 am
We ran DELETE process and later killed it. Now, we have a rollback process that is taking a very long time (estimated 14 hours) in SQL Server 2000 with SP4. The Tlog is 33 GB size. Is there a way to stop it? Thanks!
September 27, 2005 at 11:27 am
Yes, but it'll have to complete at the next server startup so you're pretty much screwed... unless you have a full backup of the db that can be restored faster and also the rollback canceled at the next restart??
September 27, 2005 at 10:12 pm
Hi Carl,
As u had written that rollback takes more than 14 hours it seems that u have millions of records.
u can issue the truncate command to drop the table with records it will faster but u cannot recover it because it is not written in tlog file.
hope this helps
from
Killer
September 28, 2005 at 6:51 am
Well it's minimally logged so it can be rolled back... if you don't overwrite the datapages with new data.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply