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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleting transaction logs

Status
Not open for further replies.

woja

Programmer
Jan 5, 2004
438
GB
Anyone got an answer to this?

Our SQL*Server (version 8.00 - SP3) we have a database maintenace plan which spcifies that transaction logs older than 2 days should be removed. But they're not. All other parts of the maintenance plan appear to operate normally. Anyone else noticed this or knows why this is not happening.

Thanks

[tt]________________________________________________________________
[pc2]Roger
Life is a game of cards in which the deck contains only jokers.[/tt]
 
Though I am not sure why this occurs ... I too have issues w/ this setting on a few of my servers. The workaround I have devised is a job that reads all of the shares I use for backup files and deletes the aniquated ones based on the creation date.

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top