Follow below steps to recover database from suspect mode:
If it does not work for you, then go for thrid 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 thrid party tool or restore database from available backups.
4 comments:
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.
repair sql database damaged .mdf files after using unstable software, hard drive fails, system errors
Utility restores tables, procedures and etc. items.
Thx!
Post a Comment