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.
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 commandselect state_desc from sys.databaseswhere name ='dbname' |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-17 : 06:36:05
|
Typically restore from backup.--Gail ShawSQL Server MVP |
|
|
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 EMERGENCYDBCC checkdb('Dbname')ALTER DATABASE Dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATEDBCC CheckDB ('Dbname', REPAIR_ALLOW_DATA_LOSS)ALTER DATABASE Dbname SET MULTI_USER |
|
|
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 ShawSQL Server MVP |
|
|
|
|
|