Knowledge Base


« Nederlands « Windows configuration

SQL Suspect Mode

If, after a SQL crash, you want to know exactly what is wrong with the database, perform the following SQL query:

DBCC CHECKDB ('YourDBname') WITH NO_INFOMSGS, ALL_ERRORMSGS
Run the following query set in the Query Analyzer to immediately start the repair:

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
Attention! CloudVPS accepts no responsibility for these queries, their execution or interpretations.

VPS Bestellen
VPS Bestellen