database maintenance plan...

I'm running SQL 2000 on W2K on two servers. The DB maintenance is set to
automatically remove old transaction log backups. A couple of months ago,
the transaction log backups stop getting tossed. I don't think it has
anything to do with whether or not the db is set to do a simple backup.
I've split the dbs between different maintenance plans and have had no luck.
I'm thinking it has something to do with a hotfix because both SQL servers
had issues about the same time.
I didn't make any changes to any of the Dbs or the SQL server that I can
remember.
Do I need to register the SQL server with Active Directory? I upgraded the
network from NT4 to W2003 and AD.Registering with AD should have no effect... Does the DBMaint Plan log show
any information?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chris Geiser" <glg.dell@.worldnet.att.net> wrote in message
news:%23CAcS9JaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> I'm running SQL 2000 on W2K on two servers. The DB maintenance is set to
> automatically remove old transaction log backups. A couple of months ago,
> the transaction log backups stop getting tossed. I don't think it has
> anything to do with whether or not the db is set to do a simple backup.
> I've split the dbs between different maintenance plans and have had no
luck.
> I'm thinking it has something to do with a hotfix because both SQL servers
> had issues about the same time.
> I didn't make any changes to any of the Dbs or the SQL server that I can
> remember.
> Do I need to register the SQL server with Active Directory? I upgraded
the
> network from NT4 to W2003 and AD.
>