HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How do I kill a rollback process when I want to drop the database?

Submitted by: @import:stackexchange-dba··
0
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.

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.