99Gb log file...help

Hello. We have had a new Win 2003 SBS Server installed 2 months ago. All has
bee ok for the last 2 months but today I have noticed that the d: drive 120Gb
partition only has just under a Gb of space left. On further inspection I
have found a 99Gb log file (log.ldf) This is under MSSQL$SHAREPOINT\Data.
Sharepoint is not even used atm.
My question is why is there a log file this large and also how do I go about
clearing it. I have read about truncation etc but a file this large seems
that there maybe something else wrong. I am fairly new to SQL etc so sorry if
not enough info but any help would be much appreciated.
Regards,
Tom.Tom,
Sounds like the database is in full recovery mode and has never been backed
up. I would truncate the log. Shrink it to something reasonable... say
500Mb. Set the recovery model on the database to simple. And even though
you don't use it today, go ahead and use the maintenance wizard to configure
and automatic backup of the database at least once per week. All of these
tasks can be done through the Enterprise manager GUI.
"Tom P via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:5262B70E980A0@.SQLMonster.com...
> Hello. We have had a new Win 2003 SBS Server installed 2 months ago. All
> has
> bee ok for the last 2 months but today I have noticed that the d: drive
> 120Gb
> partition only has just under a Gb of space left. On further inspection I
> have found a 99Gb log file (log.ldf) This is under MSSQL$SHAREPOINT\Data.
> Sharepoint is not even used atm.
> My question is why is there a log file this large and also how do I go
> about
> clearing it. I have read about truncation etc but a file this large seems
> that there maybe something else wrong. I am fairly new to SQL etc so sorry
> if
> not enough info but any help would be much appreciated.
> Regards,
> Tom.|||Look at this.
http://groups.google.ch/group/microsoft.public.sqlserver.programming/browse_thread/thread/a1f9700d9b8177b5/77157c86a71bf8f9?lnk=st&q=sql+transaction+log+large&rnum=5&hl=en#77157c86a71bf8f9
It has all got to do with the recovery setting and if you backup your log or
not.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tom P via SQLMonster.com" wrote:
> Hello. We have had a new Win 2003 SBS Server installed 2 months ago. All has
> bee ok for the last 2 months but today I have noticed that the d: drive 120Gb
> partition only has just under a Gb of space left. On further inspection I
> have found a 99Gb log file (log.ldf) This is under MSSQL$SHAREPOINT\Data.
> Sharepoint is not even used atm.
> My question is why is there a log file this large and also how do I go about
> clearing it. I have read about truncation etc but a file this large seems
> that there maybe something else wrong. I am fairly new to SQL etc so sorry if
> not enough info but any help would be much appreciated.
> Regards,
> Tom.
>|||Sorted it...Shrunk the log down to 56Mb from 99Gb...Will set a maintenance
program too.
Thnaks for all the help.
Danny wrote:
>Tom,
>Sounds like the database is in full recovery mode and has never been backed
>up. I would truncate the log. Shrink it to something reasonable... say
>500Mb. Set the recovery model on the database to simple. And even though
>you don't use it today, go ahead and use the maintenance wizard to configure
>and automatic backup of the database at least once per week. All of these
>tasks can be done through the Enterprise manager GUI.
>> Hello. We have had a new Win 2003 SBS Server installed 2 months ago. All
>> has
>[quoted text clipped - 14 lines]
>> Tom.