Mengatasi Database Supect di SQL SERVER 2005

EXEC sp_resetstatus 'yourDBname';

 ALTER DATABASE yourDBname SET EMERGENCY

 DBCC checkdb('yourDBname')

  ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER