Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Suspected Database

Author  Topic 

jhunu
Starting Member

18 Posts

Posted - 2011-12-17 : 00:27:25
How a Suspected Database can be recovered .

pnash
Starting Member

26 Posts

Posted - 2011-12-17 : 00:33:26
is there any error message found in Sql server error log?
and provide the output of below command
select state_desc from sys.databases
where name ='dbname'
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-12-17 : 06:36:05
Typically restore from backup.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

NeilG
Aged Yak Warrior

530 Posts

Posted - 2011-12-19 : 11:00:07
I'd restore of the last good backup but I have carried out the following before

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
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-12-19 : 12:14:39
Do note that the option on CheckDB there is REPAIR_ALLOW_DATA_LOSS. ie, discard anything that' damaged and fix up links. That should be a last resort for when there is no backup. Also note that it's not guaranteed to succeed

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -