May 17, 2007 at 12:51 pm
Hi,
I have fixed up the backup retention time as 1 day (i.e) i have selected 'Remove files older than 1 day' in the maintenance plan.
But i can see that some databases on the same box are maintaining upto 5 online backups,where as some 2 online backups.
Can anyone help me with this situation.
dram
May 19, 2007 at 4:04 pm
There were some issues related to maintenance plans in sql server 2005... make sure you applied sp2 before doing anything...
MohammedU
Microsoft SQL Server MVP
May 21, 2007 at 6:52 am
I have found that maint plans occasionally fail to clean up properly, also believe that maintain backups read from a table in main plan so ad hoc manual backups will not be removed by the plans.
May 21, 2007 at 8:21 am
I had some issues if I used different extensions as well. Be sure you're patched beyond SP2 with the fixes, and check your paths. There are some strange things in the maint plan.
If it still doesn't work, run Profiler while executing the package and see what's running. That might help you track things down.
May 22, 2007 at 12:48 pm
Hi All,
Thank you for your suggestions,i will try them.
dram
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply