primary database coruppeted,it is in the suspected mode want to retrive

Question

Post reply

primary database coruppeted,it is in the suspected mode want to retrive

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Messages from the SQL error log please.

Exact errors you got when querying the DB please.

I'm not able (or willing) to help without both. I don't want paraphrased descriptions. Exact messages.

As I mentioned before, if this is critical, call Microsoft's customer support. $250 is nothing compared to what a prod database down for 2 days can cost a company.

p.s. SELECT @@version?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

GT-897544 (2/23/2010)
What is the status column value when you query select * from sysdatabases.

since this is in the 2005 forums (and hence should be a 2005 database) SELECt state_desc from sys.databases is a far better option than sysdatabases, unless you like decoding bitflagged values.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SAT_SQL Default port Points: 1465 More actions · Answer 3

Hi All , now proble was resolved , it came into the normal stage .

the below procedure is what i run to get from the suspected mode to normal mode

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.

Thanks for all the help.

regards

sat

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Please be aware that by using the ALLOW_DATA_LOSS repair option you may have done just that, lost data. Please start a scheduled backup plan immediately so that if this occurs again you will have backups that you can use to recover instead of potentially lossing data.

george sibbald SSC Guru Points: 104210 More actions · Answer 5

personally I would then run another checkdb to make sure the DB was now clean.

---------------------------------------------------------------------

SAT_SQL Default port Points: 1465 More actions · Answer 6

SAT_SQL

Default port

Points: 1465

February 24, 2010 at 5:08 am

#1124203

just now i run the check db.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Lynn Pettis

SSC Guru

Points: 442467

February 24, 2010 at 5:26 am

#1124207

And?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Lynn Pettis (2/24/2010)
Please be aware that by using the ALLOW_DATA_LOSS repair option you may have done just that, lost data.

However it is the only repair level allowed when the DB is in emergency mode.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass