November 11, 2010 at 7:28 am
Hi,
I have maintenance plans running on 2 different servers and using it to backup the databases on other remote server. In the maintenance plan, I added the task of deleting older files everyday, but that is not working; everyday i have to manually delete the older files.
It is sql 2005 enterpirse edition with sp3 and i also checked the sql agent rights to the folder which has the backup.
So, I was thinking of running some automated windows script which would delete the .bak files everyday.
Can anyone help in this regard.
Regards,
Sushant
Regards
Sushant Kumar
November 11, 2010 at 8:26 am
In the Cleanup task did you enter .bak instead of bak as file extension?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 11, 2010 at 8:36 am
@ pradeep
Its bak
Regards,
Sushant
Regards
Sushant Kumar
November 11, 2010 at 9:22 am
Are the files in the main folder or sub folders? Make sure the Agent does not have a proxy as well.
I tend not to run this from a remote server, but I would likely set this to run from the local server where the backups are stored. However if you run a script, be sure that you are careful to note delete files unless there is a newer backup for that database.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply