Large log file

Hi, I am maintaning a database that is 783mb, usually the logfile is about
7mb but now it "suddenly" has grown to 1850mb!
I have been running the SQL profiler the last 24 hours, can that have
anything to do with it ? or why does it grow so large?
Does a large log file have affect on the performance? What happen if I
delete the log?
LasseDon't ever delete the log file. Read these for more info:
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Andrew J. Kelly
SQL Server MVP
"Lasse" <lars@.kpwood.com> wrote in message
news:u38iOlNnDHA.2808@.TK2MSFTNGP10.phx.gbl...
> Hi, I am maintaning a database that is 783mb, usually the logfile is
about
> 7mb but now it "suddenly" has grown to 1850mb!
> I have been running the SQL profiler the last 24 hours, can that have
> anything to do with it ? or why does it grow so large?
> Does a large log file have affect on the performance? What happen if I
> delete the log?
> Lasse
>|||Thank you.
Is it so that if there is no backup setup the log file just keep on growing,
I understand there can be other reasons but is that one reason?
Lasse
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> skrev i meddelandet
news:#IR9B6OnDHA.3288@.tk2msftngp13.phx.gbl...
> Don't ever delete the log file. Read these for more info:
>
> http://www.support.microsoft.com/?id=317375 Log File Grows too big
> http://www.support.microsoft.com/?id=110139 Log file filling up
> http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
> http://www.support.microsoft.com/?id=315512 Considerations for
Autogrow
> and AutoShrink
> http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
> Server 7.0 Tran Log
> http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
> Server 2000 with DBCC SHRINKFILE
>
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Lasse" <lars@.kpwood.com> wrote in message
> news:u38iOlNnDHA.2808@.TK2MSFTNGP10.phx.gbl...
> > Hi, I am maintaning a database that is 783mb, usually the logfile is
> about
> > 7mb but now it "suddenly" has grown to 1850mb!
> > I have been running the SQL profiler the last 24 hours, can that have
> > anything to do with it ? or why does it grow so large?
> > Does a large log file have affect on the performance? What happen if I
> > delete the log?
> > Lasse
> >
> >
>|||Yes, if the database is in full recovery and you never do log backup, then the transaction log will
never be emptied.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lasse" <lars@.kpwood.com> wrote in message news:e9ddibfnDHA.372@.TK2MSFTNGP11.phx.gbl...
> Thank you.
> Is it so that if there is no backup setup the log file just keep on growing,
> I understand there can be other reasons but is that one reason?
> Lasse
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> skrev i meddelandet
> news:#IR9B6OnDHA.3288@.tk2msftngp13.phx.gbl...
> > Don't ever delete the log file. Read these for more info:
> >
> >
> > http://www.support.microsoft.com/?id=317375 Log File Grows too big
> > http://www.support.microsoft.com/?id=110139 Log file filling up
> > http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
> > http://www.support.microsoft.com/?id=315512 Considerations for
> Autogrow
> > and AutoShrink
> > http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
> > Server 7.0 Tran Log
> > http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
> > Server 2000 with DBCC SHRINKFILE
> >
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Lasse" <lars@.kpwood.com> wrote in message
> > news:u38iOlNnDHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > Hi, I am maintaning a database that is 783mb, usually the logfile is
> > about
> > > 7mb but now it "suddenly" has grown to 1850mb!
> > > I have been running the SQL profiler the last 24 hours, can that have
> > > anything to do with it ? or why does it grow so large?
> > > Does a large log file have affect on the performance? What happen if I
> > > delete the log?
> > > Lasse
> > >
> > >
> >
> >
>