Solved

Microsoft SQL Management Studio

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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
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.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

713 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