When I query the Sys.Databases table the State_Desc column shows EMERGENCY for the database.

So I'm able to get it into emergency mode.

but when I run a query on a...

I can get it into emergency mode but i can't query the tables.

When I run the following query:

Select State_Desc From Sys.Databases where Name='HealthBookDB'

I get the following result:

EMERGENCY

So I...

I removed the existing ldf file when I run the 'CREATE DATABASE command and usually when I get the db into 'Recovery_Pending' state and run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS it...

When i run the following command:

CREATE DATABASE HEALTHBOOKDB ON (FILENAME = N'C:\HEALTHBOOKDB\HEALTHBOOKDB.mdf') FOR ATTACH_REBUILD_LOG

I get the following error:

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\HealthBookDB.LDF"...