Stuck in Restore Mode

[yeagly21]

Good Day.

I was in the process of restoring database B using database A using SQL 2005. The issue I ran into was a power surge that turned my machine off. Which has now put database A in restoring mode. I have tried to run the RESTORE DATABASE A WITH RECOVERY and it is telling me that "database cannot be recovered because the log was not restored."

My questions are is there anyway I can force the database A to come out of restoring mode? Will I be able to salvage database A or will I just need to drop it and recreate it?

Thanks

 

[mrdenny]

What does it say in the errorlog?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[yeagly21]

Denny,

Thanks for the reply.

Our IT guy removed the database ldf and mdf files by mistake. How this was accomplished I am not sure but he did it. We detached the database and then restored it from a back up.

Thanks Again for the assistance.

Yeagly