-- 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
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