Backup set will expire

If I set this option when backing up to the hard disk as 14 days, will
it delete any backup files older than 14 days?Hi
No. It just writes into the backup set that this backup may be overwritten
by SQL Server in 14 days. It does not delete the file.
In effect, you can have multiple backups in one backup file, and only after
14 days may it throw away the backup within the file.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<menlo11@.hotmail.com> wrote in message
news:1123707091.519058.272270@.f14g2000cwb.googlegroups.com...
> If I set this option when backing up to the hard disk as 14 days, will
> it delete any backup files older than 14 days?
>|||All that being said, I have tons of backup files from 2004 til today
taking up about 50 GB of space on one of our file servers. What is the
best way to handle that situation? Should I just delete most of the
backup files, just keeping the last month or so? Is there a way to
archive the earlier backups? Also, how do I stop this from happening
in the future?|||Yes, you need to make sure that old backup files are deleted so you don't fill your disks. Easiest
to automate this is to use the Maintenance Wizard do your backups. Or write your own TSQL code to do
this (most name the backup files by code where name include date and time and then delete the files
based on that name).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<menlo11@.hotmail.com> wrote in message news:1123711188.786027.258880@.f14g2000cwb.googlegroups.com...
> All that being said, I have tons of backup files from 2004 til today
> taking up about 50 GB of space on one of our file servers. What is the
> best way to handle that situation? Should I just delete most of the
> backup files, just keeping the last month or so? Is there a way to
> archive the earlier backups? Also, how do I stop this from happening
> in the future?
>