Are You Embarrassed By Your How To Recover Suspected Database Sql 2000/2005/2008 Skills? Here's What To Do
How to Recover Suspected Database SQL 2000/2005/2008 “Database suspected” a very annoying issue in the field of Data management. Some time due to sudden power failure or some other reasons our database gets suspected and we can not use it anymore. To over come this issue, there are some tricks that may be helpful to recover your suspected database 1. Restore latest backup The easiest way to make suspected database is to restore it with latest available healthy backup. It’s always very easy and secure method.. but what if you don’t have backup ? Then you need to try out second option 2. Using SQL Query You need to execute following query in query analyzer to overcome this issue EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(‘yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE your