Friday, February 18, 2011

SQL SERVER - Database Suspected in SQL Server 2008

Connected to your database and check if it is in emergency mode, else run this comand:
ALTER DATABASE DB_NAME SET EMERGENCY
set single user in the database property and run this command:
DBCC CHECKDB ('DB_NAME',REPAIR_ALLOW_DATA_LOSS)

Nicola Grillo