June 23, 2011 at 5:52 pm
good evening
i have a question
if i dindnt or cant restart the instance of a production database for a ceratin period of time (because the are may process runnning, etc) the transactios log is about to full up ?
according to the above question how often in strongly recommendable to restart the instance i.e daily, each 2 days
ill appreciate your help
🙂
June 23, 2011 at 5:58 pm
:crazy: Erm, um... no?!
Okay, there's apparently a little confusion here. The log is going to fill, constantly, even over a restart in any recovery mode besides simple. In simple, it'll simply go to the end of the log file and then start over at the beginning.
The only way to re-use log space in bulk or full recovery is to backup the log file.
Restarting the instance is a cure for other ills, which isn't a 'standard' (usually) but a last resort to get something else into play (like a trace flag) to help correct an issue. Some places will reboot a physical server once a month, but that's because of the OS, not the server.
You need to give yourself a crash course in recovery modes, the log file, and point in time recovery. You're approaching it from the wrong angle.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 24, 2011 at 12:58 am
Please read through this: http://www.sqlservercentral.com/articles/64582/
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
June 24, 2011 at 10:17 am
I never restart instances unless there are patches and I need to. The log has nothing to do with restarts, as mentioned.
Read Gail's link and manage your transaction log.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply