sql backup files: expire

Showing posts with label expire. Show all posts

Sunday, March 25, 2012

backup set will expire

|||Andre,
On the Maintenance Plan task designer (kind of like DTS / SSIS) drag the
Maintenance Cleanup Task and set it up to match your path, retention, etc.
RLF
"Andre" <nospam@.spam.com> wrote in message
news:u9DgHJpuHHA.3476@.TK2MSFTNGP02.phx.gbl...
> This was very apparent in SQL2k, but I can't find it in SQL2k5. Where is
> it?

>
|||The option you want to use has been pointed out to you by Russell. I just want to mention what the
option you mention is for:
EXPIREDATE will only prohibiting doing an INIT to overwrite the backup before the specified date. It
will not assist in keeping x number of old backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andre" <nospam@.spam.com> wrote in message news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...
> Can someone explain the option "backup set will expire" to me? I figured this would be the option
> to set how many backups I want to keep. I set it to "After 1 day", yet I have 4 days worth of
> backups in my backup directory. Did I set the wrong option? I only want 1 backup.
> Thanks, Andre
>
|||Thank you both. I will like SQL2005 one of these days...right?

Still
fumbling my way around, obviously.

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

Can someone explain the option "backup set will expire" to me? I figured
this would be the option to set how many backups I want to keep. I set it
to "After 1 day", yet I have 4 days worth of backups in my backup directory.
Did I set the wrong option? I only want 1 backup.
Thanks, AndreAndre,
Well... the others have expired, but they have not been deleted. Both SQL
Server 2000 and SQL Server 2005 Maintenance Plans have a function to delete
backup files older than some period, so you should check that out for
whatever version you are running.
RLF
"Andre" <nospam@.spam.com> wrote in message
news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...
> Can someone explain the option "backup set will expire" to me? I figured
> this would be the option to set how many backups I want to keep. I set it
> to "After 1 day", yet I have 4 days worth of backups in my backup
> directory. Did I set the wrong option? I only want 1 backup.
> Thanks, Andre
>|||This was very apparent in SQL2k, but I can't find it in SQL2k5. Where is
it? :)|||Andre,
On the Maintenance Plan task designer (kind of like DTS / SSIS) drag the
Maintenance Cleanup Task and set it up to match your path, retention, etc.
RLF
"Andre" <nospam@.spam.com> wrote in message
news:u9DgHJpuHHA.3476@.TK2MSFTNGP02.phx.gbl...
> This was very apparent in SQL2k, but I can't find it in SQL2k5. Where is
> it? :)
>|||The option you want to use has been pointed out to you by Russell. I just want to mention what the
option you mention is for:
EXPIREDATE will only prohibiting doing an INIT to overwrite the backup before the specified date. It
will not assist in keeping x number of old backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andre" <nospam@.spam.com> wrote in message news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...
> Can someone explain the option "backup set will expire" to me? I figured this would be the option
> to set how many backups I want to keep. I set it to "After 1 day", yet I have 4 days worth of
> backups in my backup directory. Did I set the wrong option? I only want 1 backup.
> Thanks, Andre
>|||Thank you both. I will like SQL2005 one of these days...right? :) Still
fumbling my way around, obviously.

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

>|||The option you want to use has been pointed out to you by Russell. I just wa
nt to mention what the
option you mention is for:
EXPIREDATE will only prohibiting doing an INIT to overwrite the backup befor
e the specified date. It
will not assist in keeping x number of old backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andre" <nospam@.spam.com> wrote in message news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...[v
bcol=seagreen]
> Can someone explain the option "backup set will expire" to me? I figured
this would be the option
> to set how many backups I want to keep. I set it to "After 1 day", yet I
have 4 days worth of
> backups in my backup directory. Did I set the wrong option? I only want 1
backup.
> Thanks, Andre
>[/vbcol]|||Thank you both. I will like SQL2005 one of these days...right?

Still
fumbling my way around, obviously.sql

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

Sunday, March 25, 2012

backup set will expire

Backup set will expire

backup set will expire

Backup set will expire

backup set will expire

Backup set will expire

sql backup files

Blog Archive

About Me