Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a development database which has entered recovery mode on restart, and has been recovering for the last hour or so.

I need to either stop the recovery, or kill it in some way.

I dont care one bit about the db or any of the data, i have deployment scripts.

Any Ideas?

share|improve this question

migrated from stackoverflow.com Jan 21 '12 at 16:47

This question came from our site for professional and enthusiast programmers.

2 Answers 2

up vote 23 down vote accepted
  • Stop SQL Server
  • Delete MDF + LDF
  • Start SQL Server
  • Restore (may need to drop first, comes up suspect)

If the MDF and LDF are present on service start up, it will go into rollforward/rollback recovery. You have to drop them to prevent this.

share|improve this answer
What if you can't stop sql server because of other databases that shouldn't go down? There is no other way? –  Erik Dekker Jan 31 '14 at 13:11
  1. Right click on the database in SQL Server Management Studio, and hit Detach.
  2. Select the Drop Connections checkbox only, and hit ok.
  3. Then the database will disappear.
  4. Right click on the Databases folder, and click Attach...
  5. Click Add and find the .mdf file for the database you deleted. You will have to find it in the file system.
  6. Click Ok, and it will be back online.
share|improve this answer

protected by Mark Storey-Smith May 20 '14 at 7:40

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?