SQL Server Repair Database related scripts DBCC CHECKDB usage from colleagues share

DBCC CHECKDB usage, manual Repair Database

1. Quick fix

DBCC CHECKDB (' database name ', repair_fast)

2. Rebuild the index and fix

DBCC CHECKDB (' database name ', Repair_rebuild)

3. If necessary allow loss of database repair

DBCC CHECKDB (' database name ', Repair_allow_data_loss)

If an error occurs: The repair statement is not processed, the database needs to be in single-user mode.

You can first enable single-user mode by executing the stored procedure as follows:

 UseMasterGosp_dboption database name, Single, True--change into a single userAlter DatabaseDatabase nameSetSingle_user with rollbackImmediate--Restoring a database to multi-user modeAlter DatabaseDatabase nameSetMulti_user with rollbackImmediate

DBCC CHECKDB usage of SQL Server Repair database-related scripts from colleagues sharing