주의대상 복구 suspect

sql server 2000 suspect 해결

USE MASTER
GO
EXEC SP_CONFIGURE 'ALLOW UPDATES',1
GO
RECONFIGURE WITH OVERRIDE
GO

UPDATE SYSDATABASES SET STATUS=STATUS|32768
WHERE NAME ='DBNAME'

DBCC REBUILD_LOG('DBNAME', 'H:\MSSQL\DATA\DBNAME_LOG2.LDF')
DBCC CHECKDB('DBNAME')
DBCC CHECKDB('DBNAME', REPAIR_ALLOW_DATA_LOSS)

UPDATE SYSDATABASES SET STATUS=STATUS&~32768
WHERE NAME ='DBNAME'

EXEC SP_CONFIGURE 'ALLOW UPDATES',0
GO
RECONFIGURE WITH OVERRIDE
GO

sql server 2005 이상 suspect 해결

EXEC SP_RESETSTATUS 'DB';
ALTER DATABASE DB SET EMERGENCY
DBCC CHECKDB(DB)
ALTER DATABASE DB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB ('DB', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DB SET MULTI_USER