snippetsqlMinor
How do I kill a rollback process when I want to drop the database?
Viewed 0 times
wantkilltherollbackhowprocessdatabasedropwhen
Problem
I want to drop a SQL Server 2008 database, but it is currently performing a rollback for a transaction (that transaction took 3 days to run so far).
How do I stop the rollback because I want to drop the database?
Thank you.
How do I stop the rollback because I want to drop the database?
Thank you.
Solution
Here's how I stopped the rollback and dropped the database.
- Stop MSSQL Server via its service applet.
- Delete the corresponding database files (the mdf and log file) from Windows Explorer.
- Restart SQL server via its service applet.
- Start SQL Management Studio, go to the corresponding database, right click and select Delete.
Context
StackExchange Database Administrators Q#78860, answer score: 2
Revisions (0)
No revisions yet.