Interrupt SQL server Rollback - TechRepublic
General discussion
June 27, 2001 at 10:52 PM
seb

Interrupt SQL server Rollback

by seb . Updated 24 years, 12 months ago

We have a very critical situation here.
We ran a stored procedure to update 6 million records in a 6.5 Sql server running under windows NT 4 (our device is about 30gb).
It ran 4 days and have been canceled.
The server is now doing a Roll back forabout 6 days.
We don?t care about data integrity since this process was updating report tables.
How can we interrupt this rollback, without entering in recovery and stop the all company ?
Is is an online production machine.

Thanks

This discussion is locked

All Comments