Log file From database Sql Server 2000

Hi,
I would like to know what can I do to with a log file that is growing very
fast.
Every 3 days I have to detach the database,delete the log file and attach
the database with out log file. During the process a new log file of 504 kb
is created.
Each day the log file is growing by 1.5 gig which is to much
Actualy I have configure for the log file Automatic Grow file by Percent 10
Also I have restrict file grow to 5000 MB which take about 4 days to reach
Is there a way that I can configure sqlServer that he can manage de log file?
You could set the recovery mode to simple which will truncate the log file
each checkpoint. However I'd double-check that this is the requirement for
this database. I use Simple recovery mode only in certain development
environments where the nightly backup is sufficient. If you need a
point-in-time recovery ability, and can't afford to lose all the work since
the last full backup, I'd recommend setting Full recovery mode and backing
up the log regularly (which will truncate the log).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||You are probably using full recovery model and not dumping (or backing up
the transaction log). I would dump it every 5 to 20 minutes or so. The
maintenance wizard will guide you through how to do this. you might also
want to delete files more than 2 days old or depending on your
recoverability requirements.
Another option is to dump to the same file each time if you don't care about
recoverability.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B33A0F0F-BA99-454D-8004-DF4181E56C93@.microsoft.com...
> Hi,
> I would like to know what can I do to with a log file that is growing very
> fast.
> Every 3 days I have to detach the database,delete the log file and attach
> the database with out log file. During the process a new log file of 504
> kb
> is created.
> Each day the log file is growing by 1.5 gig which is to much
> Actualy I have configure for the log file Automatic Grow file by Percent
> 10
> Also I have restrict file grow to 5000 MB which take about 4 days to
> reach
> Is there a way that I can configure sqlServer that he can manage de log
> file?
>
>