How To Repair A Suspect Database In MS SQL
In this video you will learn how to recover suspect or recovery pending databases using SQL Server Query analyser.
Use below queries one by one.
How to recover suspected database:
1. Select * from sysaltfiles
2.EXEC sp_configure 'Allow updates', '1'
Reconfigure with override
3.UPDATE master.dbo.sysdatabases
SET Status = -32768
WHERE [Name] = 'your Database name'
GO
4.EXEC sp_dboption 'your Database name', 'Single User','TRUE'
5.DBCC REBUILD_LOG ('your Database name', 'C:\your Database name_log.ldf')
6.use your Database name
alter database your Database name
set single_user
7.DBCC CHECKDB('your Database name', REPAIR_ALLOW_DATA_LOSS)
8.DBCC CHECKDB ('your Database name')
9.ALTER DATABASE your Database name SET MULTI_USER
done!