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 GuhathakurtaRead these articles
http://www.sql-server-performance.c...se_settings.asp
http://vyaskn.tripod.com/ sql_serve...r />
.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 phy
sical size of the log
file need to accommodate your largest transaction. there is no performance p
enalty of having a "too
big" log file. There is to regularly shrink: http://www.karaszi.com/SQLServer/in...ont_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 file
s.
> I want to and have given the log file to grow so that I have no performanc
e
> issue.
> I do backup the database every night.
> So is the only solution to detach the Server and start a new log file ever
y
> now and then or is there any better solution ?
> Thanks
> --
> Jishnu Guhathakurtasql