Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Transaction Log Files not being deleted.

Status
Not open for further replies.

pmaths

MIS
Feb 15, 2007
37
0
0
GB
As part of a Database Maintenance Plan, we backup database transation log files but have the "Remove files older than:" checkbox set to 2 days.

The problem we have is that this option of deleteing transaction files of older than two days is being ignored i.e. we have many-many .trn files in the each sql database backup directories...

Can anyone offer any advise, i.e. is there perhaps an alternative option to remove backed-up transaction files older than so many days...

Any help gratefully received.

Cheers
 
If you ask this question in a vendor specific forum they will probably be able to help you. (Your problem is DBMS specific.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top