June 11, 2005 at 2:50 pm
Hello,
I have created a maintenance plan in SQL 2000 for a database that is 35 gigs large. I get a job failure when I specify to remove files (.bak) that are 2 days are older. Below is an example of what happens.
xyz.bak 06/01/2005 first day (backup is successful)
xyz.bak 06/02/2005 second day (backup is successful)
xyz.bak 06/03/2005 third day (backup fails to remove 06/01/2005)
Thank you,
Joe
June 12, 2005 at 9:18 pm
Are you using a different file for each day?
Does the account the maintenance plan is running under have Delete permissions on the folder you are storing the backups in?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
June 18, 2005 at 7:13 am
it does have permissions and as a matter of fact this is what is happening when I clear out the folder and start fresh.
06/13/2005 - Successfull
xyz.bat 06/13/2005 12:00pm
06/14/2005 - Successfull
xyz.bat 06/13/2005 12:00pm
xyz.bat 06/14/2005 12:00pm
06/15/2005 - Failure
xyz.bat 06/13/2005 12:00pm
xyz.bat 06/14/2005 12:00pm
xyz.bat 06/15/2005 12:00pm
06/16/2005 - Failure
xyz.bat 06/13/2005 12:00pm
xyz.bat 06/15/2005 12:00pm
xyz.bat 06/16/2005 12:00pm
06/17/2005 - Failure
xyz.bat 06/13/2005 12:00pm
xyz.bat 06/16/2005 12:00pm
xyz.bat 06/17/2005 12:00pm
it does remove the second generation, but never remove the first one.
Thanks,
Joe
June 18, 2005 at 10:56 am
Ok. That's definitely weird. I'm assuming you're on at least Service Pack 3. You might want to check out Tara's scripts:
http://weblogs.sqlteam.com/tarad
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply