Thursday 29 January 2015

SQL Server DB 2008 Suspect to Normal

-- From Suspect to Normal---
Command 1: EXEC sp_resetstatus 'Tfs_Configuration';
Command 2: ALTER DATABASE Tfs_Configuration SET EMERGENCY
Command 3: DBCC checkdb('Tfs_Configuration')
Command 4: ALTER DATABASE Tfs_Configuration SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Command 5: DBCC CheckDB ('Tfs_Configuration', REPAIR_ALLOW_DATA_LOSS)
Command 6:ALTER DATABASE [Tfs_Configuration]  SET MULTI_USER

Note:
1. Here Tfs_Configuration is the database name
2. All command should be execute from master db

-- From Emergency to previous may be suspect/normal---
ALTER DATABASE Tfs_Configuration SET online