~:Suspect Database Solution for all SQL :~
Method 1 :-
(2) DBCC CHECKDB ('YourDBName', REPAIR_ALLOW_DATA_LOSS) (Run this query multiple time up to consistency error comes to 0)
(3) SP_DBOPTION 'YourDBName', 'SINGLE USER', 'FALSE'
Method 2 :-
(For SQL 2005 & 2008)
(1) DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS
Output of the above query will give the errors in the database.
To repair the database, run the following queries in Query Analyzer,
(2) EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
(3) DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
(4) DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
(5) ALTER DATABASE yourDBname SET MULTI_USER
(6) ALTER DATABASE yourDBname SET Online
Method 3 :-
(For SQL 2000)
(1) EXEC sp_configure 'Allow updates', '1'
(2) Reconfigure with override
(3) UPDATE master.dbo.sysdatabases SET Status = '-32768'
WHERE [Name] = ‘DBName’
GO
(4) EXEC sp_dboption 'DBName', 'Single User','TRUE'
(5) DBCC REBUILD_LOG ('ABC','D:\MSSQL\Data\ABC.LDF'
(6) DBCC CHECKDB ('ABC')
(7) EXEC sp_dboption 'DBName', 'Single User','FALSE'
(8) EXEC sp_configure 'Allow updates', '0'
(9) Reconfigure with override
Method 3 :-
(For SQL 2000)
(1) EXEC sp_configure 'Allow updates', '1'
(2) Reconfigure with override
(3) UPDATE master.dbo.sysdatabases SET Status = '-32768'
WHERE [Name] = ‘DBName’
GO
(4) EXEC sp_dboption 'DBName', 'Single User','TRUE'
(5) DBCC REBUILD_LOG ('ABC','D:\MSSQL\Data\ABC.LDF'
(6) DBCC CHECKDB ('ABC')
(7) EXEC sp_dboption 'DBName', 'Single User','FALSE'
(8) EXEC sp_configure 'Allow updates', '0'
(9) Reconfigure with override