Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-08-15 : 18:33:29
|
| We are forced to do the maintenance Plans driven Full Backups, in which there is a CLEANUP TASK which does the cleaning up the task 1 - day Old Full Backup.But 2005 SP2 version is naive in deleting most of the times thus enforcing the piling of old backups on to the disk space and leaving the disk space to low then followed by the total failure of even picking the next following day's backup.The solution would be easy to add extra space on to the existing disk which even accomodates the old backups before it can be manually deleted later.However, I would like to keep the Maintenance Plan driven full backup rather than any Stored Procedure based backups (as per the guidelines of organisation) but like to intimate me either through the ALERT based OR any Stored Procedure driven.I have created ALERT notification for this but is not consistent is any method that I can monitor through the code.Many Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 23:47:15
|
| First, need to figure out why it isn't deleting the old backups.Second, time to review the guidelines of the organization.Maintenance plans are useful if there's no admin or DBA on-site. Else, I'd say they have no place in an enterprise.Back to your problem...are you getting errors? What are you seeing in the maintenance plan log? |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-08-16 : 22:24:39
|
| First I dont see any error in the Maintenance plan Log, which is what the problem, unless it says something which it has failed for then that would be starting point for the investigation.However, Our maintenace plans for full backups involves like this:First procure the Full Backup of all the databases then next step in the plan is to cleanup those old Backups on securing the latest backup.This is exactly where it fails to remove the old backup.In order to overcome this imbroglio can I have any such sort of Alert or and monitoring code which indirectly notifies me.Thanks again. |
|
|
|
|
|
|
Monitor the Process