챱ͷڙzy͑(h)W(wng)վr(sh)l(f)Fһ(g)͑(h)SQL Server2005@ʾ鮐ھW(wng)ϲԃ(xn)˺ܶδޏ磺
--OÔoB(ti)
use master
go
sp_configure 'allow updates',1
go
reconfigure with override
go
--OÔoģʽ
update sysdatabases set status=-32768 where dbid=DB_ID('Procurement')
--ؽ־ļ
dbcc rebuild_log('Procurement','D:\Procurement_log.ldf')
--Cһԣʡԣ
dbcc checkdb('Procurement')
--OÔB(ti)
sp_dboption 'Procurement','dbo use only','false'
--*һ҂ҪEEOõġSϵyĿֱġһ헻֏
sp_configure 'allow updates',0
go
reconfigure with override
go
Yl(f)Fo(w)ЧϷֻʹSQL Server2000(jng)^(gu)҂һ(g)о͜yԇyKOQֻҪڔԃ(xn)Ј4дaQ
ALTER DATABASE Ĕ SET EMERGRNCY
ALTER DATABASE Ĕ SET SINGLE_USER
DBCC CheckDB (Ĕ,REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE Ĕ SET MULTI_USER