Re: Transaction Logs aren't deleted from mainenance task (newbie)
Originally posted by bobele
I created one maintenence task which backs up the data files and also the logs from some databases.
He shut delete each file after seven days, the data files are deleted, but the logs are not deleted.
Wy does he not delete the log files after seven days?
The transaction log backup occurs on 00:00 each day and the datafile backup occurs on 02:00 in the morning, which is no object in my opinion.
Thank you in advence
Gruss Gott bobele,
What do you mean that he should 'delete' the datafile? Is removing the database part of your maintenanceplan?? You mean shrink?
Do you have sql7 or 2000?