Search This Blog

Thursday, April 26, 2012

Recovering SQL Server Database From Suspect Mode

Follow below steps to recover database from suspect mode:

  1. ALTER DATABASE [database_name] SET EMERGENCY 
  2. DBCC checkdb('database_name') 
  3. ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
  4. DBCC CheckDB ('database_name', REPAIR_ALLOW_DATA_LOSS)
  5. ALTER DATABASE [database_name SET MULTI_USER

If it does not work for you, then go for thrid party tool or restore database from available backups.

18 comments:

Raj said...

Stellar SQL server database recovery is the most recommended tool by Expert database administrator for repairing suspect SQL server database. It is a Microsoft gold certified partner's product and supports recovery of SQL server 2012, R2, 2008, 2005, 2000, & 7.0.

james franklin said...
This comment has been removed by the author.
james franklin said...

repair sql database damaged .mdf files after using unstable software, hard drive fails, system errors
Utility restores tables, procedures and etc. items.

Anonymous said...

Thx!

clivee berry said...

Repair database of SQL Server MDF & NDF files from any kind of corruption situation by using SQL recovery software. This tool is capable to repair entire database of MDF file such as table, trigger, functions, stored procedures etc. Get more information about this tool from here: http://www.article.fixsqlserver.net/

Евгений Мищенко said...

Thank you very mach. Its help me and save my full working day )

Stanley D. Middleton said...

For non technical user, it is not an easy task to repair sql database mannually, i would recommend to such people, go for third party application, which is easy and fast way to recover sql database. Go to Google search there lot of tools available there, one such application is here:
http://www.recoverydeletedfiles.com/sql-database-recovery-software.html

john billy said...

When the sql database file corrupted in my computer then I think all the data lost but it is possible to sql database recovery via using tool. I save my data by using this tool.

ATGGEO said...

Ok

Ellis White said...

SQL database recovery software is one of the advanced tool that is designed to repair database from suspect mode and resolve other SQL server database issues. http://www.sqlrecoverysoftware.net/blog/repair-database-from-suspect-mode.html

Jackson Hewitt said...

Recovering SQL server database is not a big problem of any users, because third party SQL server recovery tool is available and provide by Free SQL server database recovery tool to repair and recover MDF file from corrupt and damaged SQL server. Visit here: http://www.sqldatabaserecovery.org

Christopher Messner said...

To repair and recover a corrupt MDF file you can apply any manual method but all methods are not safe and may affect your data. To recover and repair a corrupt sql file use SQL repair tool. This is the best way to repair a sql file. Free download it from :- http://www.filesrepairtool.com/sql-database-repair.html

Kaye R. Jenkins said...


Try to use SQL database recovery tool to recover corrupt SQL database without any backup of MDF file. This is capable to repair corrupt MDF file & entire database of MDF and NDF files like tables, triggers, views, functions etc. Free demo version allows users to scan, repair and view the database of MDF file.

You can download this tool from:-http://www.filesrecoverytool.com/sql-database-repair.html

Stanley D. Middleton said...

SQL database recovery application and retrieve MDF and NDF file from SQL server database. This application is compatible with all SQL version such as 2012, 2008R2, 2008, 2005 & 2000.

Get more detail:- http://www.pcrecoveryutility.com/sql-database-recovery.html

Peter Scot said...
This comment has been removed by the author.
peterscot17 said...

You can try SQL Database Recovery Software to recover and solve all types of database issue. Software is supported by all SQL Server version. Free trial version is available to users.
Quick download free trial version form - http://www.sqlrepair.org/

Maria Clark said...

Best SQL Database Recovery options to recover data from damaged or corrupt SQL databases.The software can repair both the MDF and NDF SQL database files.This software work on QFSCI algorithm and recover data in script form.

Download now:- http://www.softmagnat.com/sql-database-recovery.html

John Brooks said...

Use Sql database recovery software which can easily repair all repairs corrupt MDF file of the SQL Server database created all the SQL Server including 2016, 2014, 2012, 2008 and all lower versions and gracefully recovers SQL XML data type files also.