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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Maintenance Cleanup Task

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2012-04-12 : 10:43:03
I have posed this query in the 2005 Server and got the answer from the peers that SP4 and over have solved this problem.

The problem with Maintenance Clean Up Task is not cleaned or deleted the old backup which is older than 1-day old, but in 2008 Server of SP2 version still the clean up task is unable to delete the job.

Have no clue why it is not performing though the chronological order of Backup is able to perform without any difficulty.

Can anyone give clues (as there is no error being found in the history or errorlog or any other source for the Maintenance Plan was unsuccess).

Many thanks all.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2012-04-15 : 18:39:19
Any Invaluable Suggestions please.
Thanks.
Go to Top of Page
   

- Advertisement -