Restart Service
--------------------------------------------------
Log file lost, build a log file
--------------------------------------------------
SQL SERVER2005Workaround for database status "suspect"--MyDB for the repaired data name UseMASTERGOsp_configure'Allow UPDATES',1 RECONFIGURE withOVERRIDEGOALTER DATABASEMyDBSETEMERGENCYGOsp_dboption'MyDB','Single user','true'GODBCCCHECKDB ('MyDB','Repair_allow_data_loss')GOALTER DATABASEMyDBSETONLINEGOsp_configure'Allow updates',0 Reconfigure withOverrideGOsp_dboption'MyDB','Single user','false'GO
-------------------------------------------------
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.