SQL Server 2008 database is flagged as suspect workaround 2011-08-23 16:36 unknown fire Demon Netfont Size:T | T
In this article, we mainly describe how SQL Server 2008 databases are flagged as suspicious, and we hope to be of some help to you.
Ad:51cto Net + 12th salon: The beauty of big data-how to drive user experience with data
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 zhangxing SET EMERGENCY
2. Turn the database into single-user mode
ALTER DATABASE zhangxing 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 (zhangxing, Repair_allow_data_loss)
4. Turn the database back into multi-user mode
ALTER DATABASE zhangxing 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.
The above is the SQL Server 2008 database is marked as suspect two solutions, this article is introduced here, I hope this introduction can be a harvest for you!
Suspicious repair of SQL2008 power outage