Log Files

Hi All,
I ask the eternal question of what is the best practice to handle log files.
I want to and have given the log file to grow so that I have no performance
issue.
I do backup the database every night.
So is the only solution to detach the Server and start a new log file every
now and then or is there any better solution ?
Thanks
Jishnu Guhathakurta
Read these articles
http://www.sql-server-performance.co...e_settings.asp
http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
--administaiting best practices
"Jishnu" <Jishnu@.discussions.microsoft.com> wrote in message
news:53346E6A-7BA4-412B-9E0D-56E587E1BD68@.microsoft.com...
> Hi All,
> I ask the eternal question of what is the best practice to handle log
> files.
> I want to and have given the log file to grow so that I have no
> performance
> issue.
> I do backup the database every night.
> So is the only solution to detach the Server and start a new log file
> every
> now and then or is there any better solution ?
> Thanks
> --
> Jishnu Guhathakurta
|||If you aren't dong log backups, have the db in simple recovery mode. The physical size of the log
file need to accommodate your largest transaction. there is no performance penalty of having a "too
big" log file. There is to regularly shrink: http://www.karaszi.com/SQLServer/info_dont_shrink.asp.
Never delete the log file unless it is OK to lose the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jishnu" <Jishnu@.discussions.microsoft.com> wrote in message
news:53346E6A-7BA4-412B-9E0D-56E587E1BD68@.microsoft.com...
> Hi All,
> I ask the eternal question of what is the best practice to handle log files.
> I want to and have given the log file to grow so that I have no performance
> issue.
> I do backup the database every night.
> So is the only solution to detach the Server and start a new log file every
> now and then or is there any better solution ?
> Thanks
> --
> Jishnu Guhathakurta