Large Log Files

I have several log files, .ldf, that keep growing and growing. I have a
database maintenance plan for these in which I am backing up the transaction
logs. How would I prevent these logs from continually getting larger? I
have SQL 2000 running on a Windows 2003 standard server.
I have other databases that the .ldf files don't grow...
Any help would be appreciated.
Thank you.
Mike Stevens
As I said, I have a database maintenance plan for these in which I am backing
up the transaction logs. They create a .trn file. The .trn file is
considerable smaller than the .ldf. The .ldf file just keeps growing.
Mike Stevens
"Tibor Karaszi" wrote:

> Are you 100% certain that you do perform log backup on this database? What does the virtual file
> structure look like? (See http://www.karaszi.com/SQLServer/info_dont_shrink.asp)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Stevens" <Stevens@.discussions.microsoft.com> wrote in message
> news:94506F40-C755-43D8-9256-96EEE68E4211@.microsoft.com...
>
|||On Feb 9, 8:25 am, Stevens <Stev...@.discussions.microsoft.com> wrote:
> I have several log files, .ldf, that keep growing and growing. I have a
> database maintenance plan for these in which I am backing up the transaction
> logs. How would I prevent these logs from continually getting larger? I
> have SQL 2000 running on a Windows 2003 standard server.
> I have other databases that the .ldf files don't grow...
> Any help would be appreciated.
> Thank you.
> --
> Mike Stevens
Is the database in question enabled for replication? Define "keeps
growing and growing". How fast is it growing? Does it grow every
day, or only on weekends? Are you running a reindex job or something
that might be producing large transactions?
|||I'm quite a rookie at SQL. I'm not sure how to tell if the database is
enabled for replication. The .ldf file grows about 20-30 meg. a day. I
don't think I'm running any reindexing job.
Thanks for your help.
Mike Stevens
"Tracy McKibben" wrote:

> On Feb 9, 8:25 am, Stevens <Stev...@.discussions.microsoft.com> wrote:
> Is the database in question enabled for replication? Define "keeps
> growing and growing". How fast is it growing? Does it grow every
> day, or only on weekends? Are you running a reindex job or something
> that might be producing large transactions?
>