Log File Too Big.

Hi !
I have a small Sql server database (about 50 Mb) for a pubblic web
application.
But the log's file is is about 4 Gb and it increase very fast.......
It's normal ?
I have to set something ?
The web site has a very little amount of traffic......so there are a
little number of Sql server query.....
Thanks for your help !
Matteo Mazzoni
Matteo,
Seems like you are using Full recovery model without backing up the log. You
should backup log regularly as well. f you do not eed log backups, then
consider switching to SImple recovery model. Do please read more about
recovery model in Books OnLine. Meanwhile, this article shows ow can you
shrink the log file:
http://support.microsoft.com/default...;EN-US;272318.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Matteo Mazzoni" <Matteo Mazzoni@.discussions.microsoft.com> wrote in message
news:33E6A5A0-D5C9-4CCB-9A6F-39383E7C1C73@.microsoft.com...
> Hi !
> I have a small Sql server database (about 50 Mb) for a pubblic web
> application.
> But the log's file is is about 4 Gb and it increase very fast.......
> It's normal ?
> I have to set something ?
> The web site has a very little amount of traffic......so there are a
> little number of Sql server query.....
> Thanks for your help !
> Matteo Mazzoni
|||Another Idea may be to temporarly changing the recovery
model to simple then performing a shrink database, that
will get your disk space back.
After that you can back up your new streamline DB with the
Full Recovery model, and not use 4gb per backup.
Peter

>--Original Message--
>Matteo,
>Seems like you are using Full recovery model without
backing up the log. You
>should backup log regularly as well. f you do not eed log
backups, then
>consider switching to SImple recovery model. Do please
read more about
>recovery model in Books OnLine. Meanwhile, this article
shows ow can you
>shrink the log file:
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;272318.
>--
>Dejan Sarka, SQL Server MVP
>Associate Mentor
>Solid Quality Learning
>More than just Training
>www.SolidQualityLearning.com
>"Matteo Mazzoni" <Matteo
Mazzoni@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:33E6A5A0-D5C9-4CCB-9A6F-39383E7C1C73@.microsoft.com...
pubblic web[vbcol=seagreen]
very fast.......[vbcol=seagreen]
traffic......so there are a
>
>.
>
|||How i can changing the recovery
model to simple ?
Thanks again for your help.
"Peter The Spate" wrote:

> Another Idea may be to temporarly changing the recovery
> model to simple then performing a shrink database, that
> will get your disk space back.
> After that you can back up your new streamline DB with the
> Full Recovery model, and not use 4gb per backup.
> Peter
>
> backing up the log. You
> backups, then
> read more about
> shows ow can you
> US;272318.
> Mazzoni@.discussions.microsoft.com> wrote in message
> pubblic web
> very fast.......
> traffic......so there are a
>
|||morello
ALTER DATABASE ... SET RECOVERY SIMPLE
"morello" <morello@.discussions.microsoft.com> wrote in message
news:2E0701F1-DC46-41CE-87C7-93D1FB3BB3DA@.microsoft.com...[vbcol=seagreen]
> How i can changing the recovery
> model to simple ?
> Thanks again for your help.
> "Peter The Spate" wrote: