June 21, 2010 at 1:22 pm
HI,
I have my MSSQL database on a hoster that uses the Plesk management hosting system.
In this system they have a tool for MSSQL log file rotation ( ie daily weekly etc, compression).
I assume this just shrinks the MSSQL database log file.
What say yee, is this good practise, should I rotate or shrink my log files as often as 'daily'??
What is good MSSQL log file management ?
June 21, 2010 at 2:24 pm
If you are asking about managing transaction logs - read the article I link to in my signature. If you are asking about the error logs, then it depends on what you really need to accomplish.
I generally don't do anything special for the SQL Server or SQL Agent logs. I just let them rollover as needed based upon the default settings.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply