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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as unclear what you're asking by Jon Seigel, RolandoMySQLDBA, Paul White♦, Max Vernon, Mark Storey-Smith Mar 22 '14 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.
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:
Disclaimer: I work for ApexSQL as a Support Engineer