| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-08-09 : 18:40:06
|
| I have a maintenance plan, which has designed in such a fashion, which does the Backups of all databases on the instance, followed by Deleting 1-day-old-backup and followed by 1-day-old-transactionslogs which generate for every 15-minutes. Thus doing this Deletion of maintenance task cleanup,the Disk space is maintained.The problem is, it is doing fine for over the months, but suddenly the maintenance plan didn't worked on last couple of days and I have lost the backups being procured for these couple of days, as the disk space was full.Once a week I do as the general practise, that I will open the maintenance plan for the concerned, and will SAVE them couple of times and followed by REFRESH the Maintenance plan.I don't know whether this is correct practise of not, but to make ensure that Maintenance plans has to work appropriately and REFRESH.Can anyone please tell me since I have no other clue and as to how I need to do with perfect working of the maintenance plan not only does the backups also the chaining process under the plan that deletion will take place perfectly.Thanks all in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-09 : 19:08:03
|
| You need to have necessary space for backups. As backups are completed then maintenance cleanup task will delete the old backups. |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-08-09 : 20:39:55
|
| There is enough space earlier. But As the day-1 when backup procured there is enough space BUT, Maintenance task didn't performed to delete the day-old-backup, therefore it piled up and stored in the diskspace subsequently this occupied the disk space. 2nd day when fresh backup didn't performed due to lack of space.I understand there should have space to procure the backups, but on the first hand it should have DELETED the day-old-backups.Any Solution Please. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-10 : 16:38:02
|
| The maintenance plans will fail if any step in the job does not complete. This can result in successful backups of most of your databases. But the plan will not delete any previous backups unless all prior steps were completed successfully. So it is possible to have a full set of good backup but fail another maintenance task so nothing is deleted.In my case, someone created a new database without my knowledge in SIMPLE recovery mode.When the backup plan that targets all databases tried to do a tlog backup. it failed. All the databases were backed up successfully. But none of the file deletions were performed. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-08-12 : 00:06:44
|
| Thanks for the replies so far. However, I still have the problem.Sorry for the late reply, as I need to monitor further and give exactly what was happening with the maintenance plan.I do have good backups and Transaction logs also good. What I want is the maintenance plans need to delete the maintenance cleanup task, which it is not doing.Any Ideas as to how to get this maintenance cleanup task to get on with the job.Your Suggestions are valuable, and thanks for it. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-14 : 15:29:07
|
| You will have to figure out which step in the maintenance plan is failing. When you correct that error it will resume normal file maintenance. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-08-17 : 19:08:07
|
| I have already cross-checked teh Maintenance Plan which involves in 3-steps format. The Initial is to backup, followed by Miantenance Cleaup Task for Deleting 1-Day-old-Backup and then followed by Maitnenance CleanUp Task for removing the Previous days Log backups.Obviously, 1st and 3rd were successful, but the 2nd is sometimes unsuccessful as day-old is not deleted. Reason Unknown. Still the Maintenance plan is successful.This is the observation. Any Help Please. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-17 : 19:42:01
|
| Show us how you have setup Maintenance Cleanup task. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-08-17 : 20:21:19
|
| As I said it is the standard picture from the maintenance plan which involves with Backup Task and Maintenance Clean up Tasks. |
|
|
|
|
Maintenance Plan Failure