I NEED HELP NOW!!!

[n2jesus]

Hi all,
Came in this morning and my company database is in recovery!

The transaction log grew to 87gig over the weekend. I can't do anything with the database, not even detach it. How can I kill the transaction log, and get this database back online?

thanks for any and all suggestions.

 

[JayKusch]

Right click on the DB in question ... go to Properties..Options and set you recovery mode to Simple.

Get out of that and then again right click the DB and choose Task..Shrink..Files and in hte drop down for file type choose Log.

Click OK

Thanks

J. Kusch

 

[mrdenny]

What does the ERRORLOG say? Did the service restart and the database is still trying to come up? If thats the case you just have to wait.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog