Manitance DB Plan issue on SS 2005
-
Hello EveryOne,
I have created a DB Maintance Place on SQL SERVER 2005 and added task to cleanup(Maintance and History) the maintance plan (Only retain 2 Days bkp). But The Bkp Runs fine but does not clean up the bkp due to some issue.
I tried by creating as per Wizard and manually the DB Plans. But No Clue
why?
Can Anyone help me on this..
Thanks in Advance
-
Do you have backup files older than 2 days in that directory?
Thanks!!
The_SQL_DBA
MCTS"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
-
you can profile this and see the command being run, along with the dates passed in for removing files.
Often someone expects 2 days to mean 2 backups and they might not be the same thing.
-
wasnt there an issue with maintenance plans not cleaning up?
what version sql server do you have?
to get your version use
select serverproperty('productversion')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
-
Thanks for all the suggestions.
Let me answer each of you:
1.)Do you have backup files older than 2 days in that directory?
Yes. The log says sucess.But not deleting
2.)you can profile this and see the command being run, along with the dates passed in for removing files.
I can do that, but even i find that its not purging the old bkp.Then still i am left with the same question.
3.)
wasnt there an issue with maintenance plans not cleaning up?
what version sql server do you have?
The version is --
9.00.3068.00 (sp2)
Appericiate your support for few more suggestions
Thanks..
-
gaganks (2/13/2009)
The version is --9.00.3068.00 (sp2)
Appericiate your support for few more suggestions
Thanks..
as far as i recall that version should be fine. Double check the delete task
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply