Recovering SQL Server Database From Suspect Mode
Follow below steps to recover database from suspect mode:
If it does not work for you, then go for third party tool or restore database from available backups.
- ALTER DATABASE [database_name] SET EMERGENCY
- DBCC checkdb('database_name')
- ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- DBCC CheckDB ('database_name', REPAIR_ALLOW_DATA_LOSS)
- ALTER DATABASE [database_name] SET MULTI_USER
If it does not work for you, then go for third party tool or restore database from available backups.
Add a comment