Free Tool for SQL Server Suspect Database Repair

Rohan Wiese

Member
Steps to Repair SQL Server Suspect Database Manually

Here are the two simple methods for SQL Server Suspect Database (MDF) Repair
Manual as well as third-party SQL Suspect Repair application to repair SQL Server Database Suspect error without any data loss.
  1. Browse SSMS (SQL Server Management Studio) and connect your Suspect SQL Server database
  2. Select the New Query option
  3. Turn off the suspect flag on the database and set it to EMERGENCY
  4. EXEC sp_resetstatus ‘db_name’;
  5. ALTER DATABASE db_name SET EMERGENCY
  6. Perform a consistency check on the master database
  7. DBCC CHECKDB (‘database_name’)
  8. Bring the database into the Single User mode and roll back the previous transactions
  9. ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  10. Take a complete backup of the database
  11. Attempt the Database Repair allowing some data loss
  12. DBCC CHECKDB (‘database_name’, REPAIR_ALLOW_DATA_LOSS)
  13. Bring the database into the Multi-User mode
  14. ALTER DATABASE database_name SET MULTI_USER
  15. Refresh the database server and verify the connectivity of database

How to Fix Recovery Pending State in SQL Server Database

 
Top