sql2005æ°æ®åºä¿®å¤æ¹æ³å¦ä¸ï¼
1ãåæ¢æ°æ®åºæå¡ã
2ãå°éè¦æ¢å¤çæ°æ®åºæ件å¤å¶å°å¦å¤çä½ç½®ã
3ãå¯å¨æ°æ®åºæå¡ã
4ã确认è¦æ¢å¤çæ°æ®åºæ件已ç»æåå¤å¶å°å¦å¤çä½ç½®ï¼ç¶åå¨SQL Server Management Studioä¸å é¤è¦æ¢å¤çæ°æ®åºã
5ãæ°å»ºååçæ°æ®åº(æ°æ®åºæ件åä¹è¦ç¸å)ã
6ãåæ¢æ°æ®åºæå¡ã
7ãç¨ç¬¬2æ¥ä¸å¤ä»½ç.mdfæ件è¦çæ°æ°æ®åºçååæ件ã
8ãå¯å¨æ°æ®åºæå¡ã
9ãè¿è¡alter database dbname set emergencyï¼å°æ°æ®åºè®¾ç½®ä¸ºemergency mode
10ãè¿è¡ä¸é¢çå½ä»¤å°±å¯ä»¥æ¢å¤æ°æ®åºï¼
Title
use master
declare @databasename varchar(255)
set @databasename='è¦æ¢å¤çæ°æ®åºå称'
exec sp_dboption @databasename, N'single', N'true'
dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)
dbcc checkdb(@databasename,REPAIR_REBUILD)
exec sp_dboption @databasename, N'single', N'false'
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='DataCenter'
Go
sp_dboption 'DataCenter', 'single user', 'true'
Go
DBCC REBUILD_LOG ('DataCenter', 'D:\Database\ic\DataCenter_Log.LDF')
Go
DBCC CHECKDB('DataCenter')
Go
update sysdatabases set status =28 where name='DataCenter'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'DataCenter', 'single user', 'false'
Go
温馨提示:答案为网友推荐,仅供参考