The database displays a suspect repair method

When using SQL Server database to find that the database is flagged as suspect , view the information on the Internet finally found a solution, then we will introduce the solution.

Workaround:

When this operation failure occurs in the database, you can resolve this by following the steps below, open the SQL Query Editor window in the database and run the following command.

1, modify the database for emergency mode

ALTER Database name SET EMERGENCY

2. Turn the database into single-user mode

ALTER Database name SET single_user

3. Repair the database log rebuild, this command checks the allocation, structure, logical integrity and errors in all database objects. When you specify "Repair_allow_data_loss" as the DBCC CHECKDB command parameter, the program examines and fixes the reported errors. However, these fixes may cause some data loss.

DBCC CheckDB (database name, Repair_allow_data_loss)

4. Turn the database back into multi-user mode

ALTER Database name SET multi_user

You can also do this:

1: Re-establish a, same database, path name, file all the same.

2: Turn off SQL Server service;

3: Copy the source files.

4: The SQL Server service is turned on, so the problem is solved.