March 23, 2006 at 12:01 pm
Hi,
I dont want to use the maintenance plan wizard - for some reasons sometimes it fails.
In there - i have it to delete all backups and trans logs older than one day(current one)..... but it doesnt happen
How to write a job that does exactly or similar to the maintenace plan wzd so that it deletes the .bak and .trn files older than current date and also the transaction log space should not be big.... (i shouldnt be shrinking the file every now and then to clean disk space)
Plz let me know regarding this.
Thnx,
Natalie.
March 23, 2006 at 11:28 pm
In Database maintinance plan when u define backup disk directory there is a option remove file older then no of days.
There u can define number of days.It will delete the files older then the number of days given before it start the backup.
U should have enough space to keep one week backup files
from
Killer
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply