Solved

Microsoft SQL Management Studio

Posted on 2014-04-23
4
275 Views
Last Modified: 2014-04-23
I am backing up an SQL database with an SQL Management Studio 2005 Maintenance plan. I can't figure out how to configure it so that it doesn't fill up my backup folder and consequently my disk. I have to manually go in and delete old backups. Is there a retention setting or overwrite option that I am missing?
0
Comment
Question by:penntechs
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
David Kroll earned 500 total points
ID: 40017635
0
 
LVL 11

Expert Comment

by:David Kroll
ID: 40017690
Jim - understood.

Look into the "Define Maintenance Clean Up" page of the task. You can choose a certain file type and how long to keep files.
0
 

Author Closing Comment

by:penntechs
ID: 40017745
Thank you. Exactly what I needed
0

Featured Post

Why do Marketing keep bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now