Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem in Maintenence Cleanup Task -- urgent Expand / Collapse
Author
Message
Posted Wednesday, March 25, 2009 12:47 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 6:43 AM
Points: 99, Visits: 243
Hi every body,

I just create a Maintenence Cleanup Task and connect to the Maintenence Plan backup.The backup was creating successfully but the deleting of 1 day old files was not getting done.
I gave the start time as 12:00:00 Am to 11:59:59 PM yesterday itself(it means to run for 24 hours).But its not deleting the back up file which was created on yesterday 12:00:14 pm.


Venu Gopal.K
Software Engineer
INDIA
Post #683078
Posted Wednesday, March 25, 2009 3:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,606, Visits: 1,039
Actually usin Maintenance plan Wizard you separately schedule multiple maintenance task.

While creating the maintenance cleanup task did you give the folder path and file extensions properly.
Did you set on success precedence constraint



Tanx
Post #683143
Posted Wednesday, March 25, 2009 5:23 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 6:43 AM
Points: 99, Visits: 243
I am not using the Minatenence plan whizard. I just create a new MP by right click the Maintenance tab and selecting New Maintenence plan tab.
Tell me exactly what "Did you set on success precedence constraint" this mean?


Thank u.


Venu Gopal.K
Software Engineer
INDIA
Post #683190
Posted Wednesday, March 25, 2009 5:25 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 6:43 AM
Points: 99, Visits: 243
I am not using the Minatenence plan whizard. I just create a new MP by right click the Maintenance tab and selecting New Maintenence plan tab.
Tell me exactly what "Did you set on success precedence constraint" this mean?


Thank u.


Venu Gopal.K
Software Engineer
INDIA
Post #683191
Posted Wednesday, March 25, 2009 9:40 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,606, Visits: 1,039
That is the connection between the two jobs in your maintenance plan .

On success/failure/completion of the first job the work flows to the next job.


Tanx
Post #683821
Posted Monday, March 30, 2009 1:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, February 25, 2015 3:05 PM
Points: 942, Visits: 1,072
Hi Venu,

Two reasons your backups might not be deleting ...

1) you are running SQL Server 2005 version which had a glitch in the "Maintenance Cleanup" task.
2) Your backup time is set to 24 hours, so if the files were even 1 second too late they will not delete. Meaning...

Lets say your backup starts at 12:00AM and Finishes at 12:15AM.

Your delete starts then it will look for all files starting at 12:15:01AM yesterday. If the the file was finished creating at 12:15:00AM it will not delete... because it's 1 second short of reaching 24 hours. I usually set my hours delay to 20 hours to delete.

Thanks.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #685893
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse