블로그 이미지
불쥐의 눈으로 본세상 ㏈ª ☞ β┖υΕJini.κR

카테고리

분류 전체보기 (234)
By β┖υΕJini (131)
㏈ª By β┖υΕJini (103)
Total274,031
Today31
Yesterday104
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
Posted by ㏈ª ☞ β┖υΕJini.κR