If u have a SQL Server 2005 database in suspect mode,we can change the database from Suspect mode to Emergency mode, so that you can retrieve the data in read only mode which is introduced in SQL Server 2005.Please follow the following steps to change the database status from suspect to emergency than to it's normal state:
EXEC sp_resetstatus 'DBname'
ALTER DATABASE DBname SET EMERGENCY
DBCC checkdb('DBname')
ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DBname SET MULTI_USER
No comments:
Post a Comment