February 25, 2013 at 6:56 pm
I am a newbie and we ran a script that made our logfile drive go to 100%. We tried to do a restore of the database and now the database will not come up. Any suggestions would be appreciated.
February 25, 2013 at 7:46 pm
What is the status of your databse as per management studio?
What error you have in your error log?
February 25, 2013 at 7:48 pm
February 25, 2013 at 7:49 pm
We are currently not getting any errors . The database status show (inRecovery). There is a lot of read on the log file directory.
February 25, 2013 at 7:51 pm
It is a production database. We restored it since the transaction we ran did not complete and we had to remove it.
February 25, 2013 at 8:02 pm
How did you restore the database?.
While restoring did you add with norecovery?
February 26, 2013 at 12:04 am
Whats current Log size? and database size?
if its showing Inrecovery then wait for some time let database recover and then shrink database log file or change recovery mode to simple
February 26, 2013 at 3:48 am
Please read through this - Managing Transaction Logs[/url] and - http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Don't just shrink or change recovery models without analysing and knowing the effects of the actions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2013 at 2:43 pm
Hmm, now that the db is in recovering status, you may not be able to (temporarily) add another log file on a different drive to allow the db to keep processing while you clean up.
Instead, see if there is another db(s) with large log file(s) that you can afford to do w/o for a few seconds/minutes while you move their log file(s) to another drive.
That is, your log drive needs free space to do work in. It's full. You can free up space on that drive by moving one (or more) of the other log files to a different drive temporarily).
That might (or might not) allow the original db to complete recovery.
If you want to try moving an existing db's log to another drive temporarily, let me know, and I can help you build a script to do it. NOTE: you should use ALTER DATABASE, NOT detach to do this.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply