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.googlegr oups.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.googlegr oups.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?
>

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?
>

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 fi
ll 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 an
d 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.googlegroup
s.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?
>

Backup files

Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanksWhat I have done here is to have two scheduled maintenance plans for backing up. One that runs every 24 hours that overwrites every time, and a second that appends an incremental every three hours. We then store everything on tape for two weeks.

When you set up the job there is a radio button group to select overwrite or append. If you want to edit your job step change NOINIT to INIT and then the job will overwrite.

Originally posted by Sia
Hi,
I have a scheduled maintenance plan for backing up my database.
I have recently ran out of space and I need to delete some old back up files.

Question:
if I make a backup of a database (full backup) if I want to restore my databse using the transaction logs I can only go back to the latest backup?
If so, why should I keep my old backup files?
Is there any way to tell sql server to overwrite backup files each time it makes a back up and is this a good idea?

thanks