I have SQL Express 2008 and SQL 2008 both installed on a server. There are a variety of dbs installed on SQL Standard all with many backups. SQL Express has only 4 small dbs and it turns out these are only backed up using DPM 2010.
One of these is stuck on recovery_pending, apparently since August 31. It is a blog with irregular entries and absence was not noted.
I tried all the steps at
http://sqlhera.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-EMERGENCY-mode-repair-the-very-very-last-resort.aspx. The SET Emergency and also the SET Single_User command reports success, but then the DBCC part just says:
Msg 922, Level 14, State 1, Line 1
Database 'emergencydemo' is being recovered. Waiting until recovery is finished.
At this point there is only one backup in DPM dated August 30. I restored this to a different location and tried to attach it ot SQL Standard, but it fails:
Database 'emergencydemo' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Could not open new database 'emergencydemo'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 3415)
It is looking pretty grim for both the database and the backup.
View Complete Post