Recently, I needed to stop a rollback process for a database and drop the database, as the rollback process estimated that it will take 3.5 days!

Here's how I stopped the rollback and dropped the database.

  1. Stop MSSQL Server via its service applet.
  2. Delete the corresponding database files (the mdf and log file) from Windows Explorer.
  3. Restart SQL server via its service applet.
  4. Start SQL Management Studio, go to the corresponding database, right click and select Delete.