MSSQL页断裂的维护修复和损坏的恢复方法

注：替换DATABASENAME为你的数据库名称

1. MSSQL页断裂的维护和修复

USE MASTER

GO

SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE

GO

sp_dboption DATABASENAME, 'single user', 'true'

Go

DBCC CHECKDB(DATABASENAME,REPAIR_ALLOW_DATA_LOSS )

Go

sp_configure 'allow updates', 0 reconfigure with override

Go

sp_dboption DATABASENAME, 'single user', 'false'

Go

2. 断电造成数据库损坏的恢复方法

ALTER DATABASE DATABASENAME SET EMERGENCY

ALTER DATABASE DATABASENAME SET SINGLE_USER

DBCC CheckDB (DATABASENAME , REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE DATABASENAME SET MULTI_USER