Transaction log .TRN files not being removed

[barbola]

We are using Great Plains on SQL 2000, but I thought I'd post this in the SQL forum rather than Great Plains.

We have a maintenance plan to run an hourly transaction log backup and a daily database backup (separate plans).

The transaction log backup is set up to remove trn files older than 7 days, yet they are not deleting. I have removed and re-set up the maintenance plan, and still the files are accumulating.

We have run into problems where the data drive on the server is full and the server crashes. This is bad and we have no way of being notified when it's filling up (I told the I/T guy to fix that so I get notified but it hasn't been done cuz in my opinion he doesn't know how to do it).

Anyone else know what's wrong and why the files are not being removed? This is the sql statement I found:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID D576F081-6DB6-4DC0-9A66-BEC6681B876C -Rpt "d:\MSSQL$SQL1\LOG\TransactionLogHourly6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "D:\MSSQL$SQL1\BACKUP" -DelBkUps 5DAYS -CrBkSubDir -BkExt "TRN"'

Thanks!
Barb E.

 

[mrdenny]

This is one of the problems with the maintaince plans. If it things that any little thing is wrong it won't delete the old files and you end up having to delete the manually. Check the Reports in the d:\mssql$sql1\log folder and see if there is anything in about why it's not deleting. The logs for this maintaince plan at TransactionLogHourly6*.txt

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[barbola]

I had checked earlier and I noticed that two of our approx 30 databases were showing an error. This was because they were set as Simple instead of Full and this was probably causing the failure to delete files.

The trans log backups worked fine last hour and I will have to check in a few days to see if old files are actually being deleted.

I manually deleted them earlier so I can't check just yet.

thanks so much!

Thanks!
Barb E.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief