Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Microsoft SQL Management Studio

Posted on 2014-04-23
4
Medium Priority
?
283 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
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.

886 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