Discussion Locked

Interrupt SQL server Rollback

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by steved

In Enterprise Manager, under Management/Current Activity/Process Info, identify the process that is doing the rollback. Then kill it (right-click/Kill Process). It may take a while (minutes) but it should eventually be able to kill it.

I hope this helps.

Steve Diamond

by seb

Thanks Steve, this had been tried, and did not work, according to Microsoft, it is not possible to kill a rolling back process.

by jmiller1

One possibility is to stop the MSSQLServer service, and rename the files that comprise your database. When the server comes back online, it wont be able to find your database, thus it can't roll it back. Then create new devices and restore from your latest backup and you will be back online.

This discussion is closed to new replies.