We help IT Professionals succeed at work.
Get Started

Maintenance plan problems

sharscho
sharscho asked
on
389 Views
Last Modified: 2012-05-09
Hello experts, I have problems with backup maintenance plans of sqlserver 2000. I have a plan for user dbs and a plan for system dbs. The one of user dbs has 1 db of 32G and a db of 15G. The idea is that the MP remove files older than 3 hours so that only one backup copy remains on disk. This is due space issues on this server. They don't want to invest in this since they will be using another application soon (I hope). The MP does not remove the older copies of the biggest db and we can problems with the backup of the db of 15G. What I di now is, I made a seperate MP for each big database adn so seperate them from the others and let it run at different times. But can someone tell me why sqlserver 2000 does this? Why it does not remove the files like it is told to do? The server runs ms win 2003.
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE