修复数据库
数据库显示(可疑)
SQL2000修复语句:
USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE GO UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='test' Go sp_dboption 'test', 'single user', 'true' Go DBCC CHECKDB('test') Go update sysdatabases set status =28 where name='test' Go sp_configure 'allow updates', 0 reconfigure with override Go sp_dboption 'test', 'single user', 'false' Go
SQL2008 修复
ALTER DATABASE test SET EMERGENCY GO ALTER DATABASE test SET SINGLE_USER GO DBCC CheckDB (test , REPAIR_ALLOW_DATA_LOSS) GO ALTER DATABASE test SET MULTI_USER GO
心若没有栖息的地方,到哪里都是在流浪!
——蓅烺ゞの貓