SQL Server 복구 하기

SQL2000

sp_configure 'allow', 1 reconfigure with override

begin tran
update sysdatabases set status=32768 where name = 'DB'
commit tran

dbcc rebuild_log('DB', '경로')

begin tran
update sysdatabases set status = 0 where name = 'DB'
commit tran

-- mdf 파일로 로그파일을 재구성

sp_dboption DB, single, true

alter database drbitpack
dbcc checkdb ('DB', REPAIR_FAST)

alter database DB
set multi_user

 

SQL2005

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

참고 : How to Restore SQL Server 2005 Suspect Database
http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx