Solved

Microsoft SQL Management Studio

Posted on 2014-04-23
4
278 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

825 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