SQL Database in (Emergency) mode, need advice?

Emergency Mode databases can be reset to Online, iff it has been set by a user. I once ran into same grave and solved it by discarding its LOG file using ATTACH_REBUILD_LOG. More at my post here - http://www.sqlservercentral.com/Forums/Topic399609...

But in your case, it has now moved into next phase - EMERGENCY. Perform steps as told in above post and if it doesn't work, try resetting the status by executing these commands

DBCC CHECKDB ('YourDBname', REPAIR_ALLOW_DATA_LOSS)

GO

ALTER DATABASE YourDBname SET ONLINE

GO

ALTER DATABASE YourDBname SET MULTI_USER

Post us back the results... lets see if we can be of any help.

--In 'thoughts'...

Lonely Rogue.

there is another strategies in show for scripting the database. The utility i discussed in the previous supplies you a effective interface for producing a script that is composed of schema and documents. i'm enormously particular there will be a manner in sqlexpress to try this too. to furnish the terrific-of-type information superhighway information superhighway hosting at terrific in industry pricing To rejuvenate the low fee, low high quality image linked with our opposition To make information superhighway information superhighway hosting a extra friendly and relaxing experiencefor the tip person Namecheap is a genuine 10 area registrar placed in la, CA