Hi,
I am using SQL Server database 2008 R2. How can I repair my database from the suspect mode?
Printable View
Hi,
I am using SQL Server database 2008 R2. How can I repair my database from the suspect mode?
restoring from good backup is best way.
I do not have updated backup
Hi Ted,
Read this blog : http://data-base-recovery.blogspot.i...r-2008-r2.html
Run this query:
EXEC sp_resetstatus ‘YourDatabaeName’;
ALTER DATABASE YourDatabaeName SET EMERGENCY
DBCC checkdb(’YourDatabaeName’)
ALTER DATABASE YourDatabaeName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (’YourDatabaeName’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE YourDatabaeName SET MULTI_USER
in 80% cases, this query help to repair the database.
Good Luck!
Thanks a lot Nicholas for your help. It works