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 StevensAlso, do you have some old open transaction? (DBCC OPENTRAN)
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...
>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 transacti
on
> 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|||Are you 100% certain that you do perform log backup on this database? What d
oes the virtual file
structure look like? (See http://www.karaszi.com/SQLServer/in...ver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stevens" <Stevens@.discussions.microsoft.com> wrote in message
news:94506F40-C755-43D8-9256-96EEE68E4211@.microsoft.com...
>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 transacti
on
> 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 backin
g
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/in...ver/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 transacti
on
> 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?|||What about the virtual log file structure, and result from DBCC OPENTRAN?
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:CA33D6C4-850B-4E77-AADB-11EF06A11BBA@.microsoft.com...[vbcol=seagreen]
> As I said, I have a database maintenance plan for these in which I am back
ing
> 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:
>|||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?
>