Use SQL statements to repair SQL Server databases

Use SQL statements to repair SQL Server databases

When using the SQL Server database, some small errors may occur in the database due to power failure or other reasons, such as the slow retrieval of some tables and the failure to query Qualified Data.

The reason for these problems is that the database is damaged or the index is incomplete.

In ACCESS, there is a function to fix the database to solve this problem. In SQL Enterprise Manager, this function is not available and should be completed using statements, the following describes how to use SQL statements to fix databases. Note that all users must be disconnected during the following operations:

USE MASTER

GO

Sp_dboption ''your database name'', ''single user'', ''true''

Go

Dbcc checkdb (''your database name'', REPAIR_REBUILD)

Go

USE your database name

Go

Exec sp_msforeachtable ''dbcc CHECKTABLE (''''? ''', REPAIR_REBUILD )''

Go

Sp_dboption ''your database name'', ''single user'', ''false''

Go

This article permanently updates the link address: