SQL Server database (suspicious) workaround

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

--1, modifying the database for emergency mode

ALTER DATABASE zhangxing SET EMERGENCY

--Always remember to restart the service after operation

--2 the database into single-user mode

ALTER DATABASE zhangxing SET single_user

--3, repairing database log rebuilds, this command checks the allocation, structure, logical integrity, and error of objects in all databases. 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 (zhangxing, Repair_allow_data_loss)

--4, changing the database back to multi-user mode

ALTER DATABASE zhangxing SET multi_user

SQL Server database (suspicious) workaround