• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Microsoft SQL Management Studio

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
penntechs
Asked:
penntechs
  • 2
1 Solution
 
David KrollCommented:
0
 
David KrollCommented:
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
 
penntechsAuthor Commented:
Thank you. Exactly what I needed
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now