Database in 'Recovery Pending' State -Error 945

Question

Database in 'Recovery Pending' State -Error 945

Viewing 6 posts - 31 through 35 (of 35 total)

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

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

Wait. CheckDB has to complete. Since the DB is in single user mode, you won't be able to connect to it from any other session.

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

Vertigo44 SSCarpal Tunnel Points: 4055 More actions · Answer 2

IT WORKED!!!! DBCC came back with only 1 inconsistancy and fixed 1 inconsistancy. It also told me the table where to find it in. I selected the audit table and found a date time column. It showed data right up until the time it went down! This is excellent news! Thanks for all the assistance guys! I really appreciate it!

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

Bear in mind there may still be transactional inconsistencies (where part of a transaction completed only), you could have orphaned rows (foreign key constraints that are now violated)

You need to check for stuff like that, but it needs knowledge of how the system works and what the data means.

Also run CheckConstraints, run a checkDB (without repair) and make sure that they don't pick any other problems up

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

Vertigo44 SSCarpal Tunnel Points: 4055 More actions · Answer 4

Yes, I will work with one of their application users to check for missing / partial data. Thanks again for all your help and advice. This has been quite the learning experience!

Satish S Mr or Mrs. 500 Points: 580 More actions · Answer 5

Hi

I have faced same issue after updating SP.

When the Database take offline and back to online its work fine...

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 6

satish.saidapur (8/22/2014)
Hi
I have faced same issue after updating SP.
When the Database take offline and back to online its work fine...

That is a really dangerous thing to do. There is no guarantee that any database in this state taken offline will ever be able to come back online.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.