SQL Server 2005/2008 database is marked as "suspicious" solution _mssql2005

Problem background:

When you work with a SQL Server 2005 relational database on a day-to-day basis, there are times when the database, such as the SharePoint site metabase name Sharepoint_config, is not functioning as if the database stopped the database for no reason, resulting in SQL Server 2005 database abnormal interrupt, when again open the database will be found that some database will be marked as "suspicious" (suspect), that is, the database name by adding a yellow exclamation point, then the database can no longer be opened, but the structure of the database and data content are still there.

Workaround:

When this operation fails in the database, you can resolve this method by opening the SQL Query Editor window in the database and running the following command.

1, modify the database for emergency mode

ALTER DATABASE sharepoint_config SET Emergency

2, make the database into a single user mode

ALTER DATABASE sharepoint_config SET single_user

3. Repair Database log Regeneration, this command checks the allocation, structure, logic integrity and all database object errors. When you specify "Repair_allow_data_loss" as the DBCC CHECKDB command parameter, the program checks and repairs the reported errors. However, these fixes can cause some data loss.

DBCC CheckDB (Sharepoint_config, Repair_allow_data_loss)

4, make the database back to multiuser mode

ALTER DATABASE sharepoint_config SET multi_user

5, start-> run-> input cmd-> open the DOS command window, enter the following command to restart the database service

Net stop MSSQLSERVER-stop service

Net start MSSQLSERVER-start service

Again, the database that was marked "suspicious" when you opened SQL Server 2005 has been restored to its normal state.