Hi Paul,

I have similar issue yesterday occurred after upgrading to the new version sql2008r2 from 2005 version. We haven't changed the compitible mode after the upgarde.

I have followed all steps in your blogpost

Initially, I have tried regular recover option like below

ALTER DATABASE [MYDB] SET EMERGENCY;

GO

ALTER DATABASE [MYDB] SET SINGLE_USER;

GO

DBCC CHECKDB (N'MYDB', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;

GO

But received Error:

The database 'MYDB ' is in 611. The database needs to be updated to the latest version.

Then I followed your blog post below:

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/

As it is reporting database, we are not concerned about the data but need the reporting store procedure from the corrupted dB.

Issue: DBCC checkdb cannot be run , also I checked other post of you on fatal errors where dbcc checkdb can not be run, In this case Is there anyway we could get the stored procedures out of the corrupted database.