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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-07-23 : 20:32:59
|
| We run jobs through the Maintenance Plans which are doing accordingly.Maintenance plans deals with backup daily, but while job performs to procure the backup at 11 PM it went into the wee-hours of next day between 12 AM – 1 AM, which is also good.However, my maintenance plans were designed to delete the day-old-backups, at this stage they were identified as TODAY’s backup so it is not deleting them.For this I have advanced my backup instead of 11PM to 10 PM but still Day-old-Backups were not deleted and I have to delete them manually.Does this something wrong with the maintenance plans design and need to get redesign?Please analyse my problem and your suggestion would be really valuable. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-24 : 05:20:58
|
quote:
Originally posted by dbalearner
We run jobs through the Maintenance Plans which are doing accordingly.Maintenance plans deals with backup daily, but while job performs to procure the backup at 11 PM it went into the wee-hours of next day between 12 AM – 1 AM, which is also good.However, my maintenance plans were designed to delete the day-old-backups, at this stage they were identified as TODAY’s backup so it is not deleting them.For this I have advanced my backup instead of 11PM to 10 PM but still Day-old-Backups were not deleted and I have to delete them manually.Does this something wrong with the maintenance plans design and need to get redesign?Please analyse my problem and your suggestion would be really valuable.
pls post the maintenance cleanup tasks tsql |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-24 : 22:15:33
|
| Do you have latest service packs ? It was fixed in SP 2 or above. |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-07-28 : 18:14:17
|
| Yes We do have the Latest Service pack SP2, but still no evidence for my problem. |
|
|
|
|
|
|
Maintenance plans