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.

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore .mdf file.

share|improve this question

closed as unclear what you're asking by Jon Seigel, RolandoMySQLDBA, Paul White, Max Vernon, Mark Storey-Smith Mar 22 at 8:52

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Do you have good backups? Or is that what you mean by standard procedures? –  Wind Raven Mar 21 at 12:24
1  
Is the status "suspend" or "suspect"? –  Sebastian Meine Mar 21 at 12:33
1  
What errors are there in error log ? –  Kin Mar 21 at 13:00

1 Answer 1

I guess the problem is that the database is in suspect mode, not suspend

First of all, it's not recommended to detach it, if you do that, most probably all you're left with is a third party tool, such as ApexSQL Recover that can read the MDF file to recover the table records. Use the Recover from a corrupted database or a detached MDF file option

While the database is still attached to SQL Server, you can try the steps suggested by Paul Randal - use the emergency mode, switch to the single user mode, and try with ATTACH_REBUILD_LOG and DBCC CHECKDB

You have detailed explanation here:

Creating, detaching, re-attaching, and fixing a SUSPECT database

EMERGENCY-mode repair: the very, very last resort

Disclaimer: I work for ApexSQL as a Support Engineer

share|improve this answer
2  
+1 for necessary disclaimer. –  Zane Mar 21 at 16:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.