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:

Professional Opinions
Ask a Question
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

troubleshooting Question

Need to find and delete existing backups, then modify maintenance plan to delete old backups

Avatar of TexasGaidheal
TexasGaidhealFlag for United States of America asked on
Microsoft SQL Server 2008
2 Comments1 Solution286 ViewsLast Modified:
I have a disk space problem on a SQL Server 2008 system caused by a maintenance plan (which I did not create) which does daily backups, creating new backup files with each backup. The plan does nothing to delete old backups, with the result that I am running out of disk space.

I am not an experienced SQL Server DBA; I have never used the Maintenance Plan Wizard or the editor that is used to modify existing maintenance plans, so any instructions will have to be fairly detailed.

Problem 1: I need to find where the backup files are, so that I can see how big they are , so that I can decide how many of them I need to delete, as an immediate manual cleanup. I could find them with Windows explorer on the server, and see how big they are, but I suspect that deleting them at that point would not be a good idea. How can I find and manually delete these backups with the SQL Server Management Studio? I expect that it should be possible, but I have found nothing yet by digging through the Object explorer and the multitude of subitems and menus.

Problem 2: editing the existing backup maintenance plan so that it deletes old backups when new ones are created. As I said above, I have never created or modified a maintenance plan. I can see from answered questions that I need to do a Modify on the existing maintenance plan and add a Cleanup Task, but I see that there are two kinds of Cleanup Task available: History Cleanup Task and Maintenance Cleanup task. I need to know which one I should use and detailed instructions as to how I should integrate it into the existing plan. I can drag one of the tasks from the toolbox into the design pane, but I have no idea of what to do next. (The amount of documentation and help files in SQL Server Management Studio is so large and poorly indexed as to be useless.)
Avatar of Sharath S
Sharath SFlag of United States of America imageData Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers