If you have trouble starting a server or database, if the database starts but you are unable to connect to it, or if problems are found during database verification, this section helps you determine the action you should take to resolve the problem.
Decision flow for server recovery and database
repair
Does the server start?
If the server starts, go to step 2.
If the server does not start, refer to the section “Server operational issues”. If you cannot start the server after following the suggestions in this section, then refer to the section “Starting servers in forced recovery mode” and start the server in forced recovery mode.
If the server does not start in forced recovery mode, call Technical Support. A restore of the database from backup may be necessary.
Can you connect to the database?
If you cannot connect to the database, refer to the section “Database connection issues” for troubleshooting suggestions.
If you can connect to the database and you previously started the server with forced recovery, refer to the section “Analyzing allocation problems” for information on verifying database allocation and recovering leaked blocks.
If you can connect to the database, but suspect the database may be inconsistent, refer to the section “Database verification” for information on checking the consistency of your database.
The server is running and you can connect, but you want to verify the consistency of your database.
If you previously started the server with forced recovery or you suspect database inconsistency, you should run DBCC checks to validate the database. Refer to the section “Database verification” for information on checking both index consistency and database allocation.
The server is running, you can connect, you have run DBCC checks, and you need to repair the index inconsistencies or allocation problems detected by DBCC.
If sp_iqcheckdb reports errors in the Index Summary and Index Statistics sections of the results, refer to the section “Repairing index errors” for the procedure to repair index problems using DBCC.
If sp_iqcheckdb reports errors in the Allocation Summary and Allocation Statistics sections of the results, refer to the section “Repairing allocation problems” for the procedure to repair allocation problems using DBCC.
