SQL server database in suspect mode

[Nicholas J]

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!

[ted]

Thanks a lot Nicholas for your help. It works