[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

delete old sql .bak files

sql server 2005 enterprise
scheduled backup

is there a way to delete the old backups or set a maximum folder size so the folder does not get too big

all I want is the latest backup
0
rgb192
Asked:
rgb192
2 Solutions
 
robertg34Commented:
Look in the maintenance plans under management and use the maintenance cleanup task.  

http://msdn.microsoft.com/en-us/library/ms345177.aspx

0
 
rgb192Author Commented:
thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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