|
Home > Archive > MS SQL Server > June 2005 > SQL Backup expire date....
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Backup expire date....
|
|
| Jessy Martin 2005-06-01, 1:23 pm |
| In the SQL Server backup documentation I am seeing some reference to expire
date. Expire date has any impact on if we need to restore the database after
two years or so.
I am using SQL 2K.
Thanks,
Jessy
| |
| Rick Sawtell 2005-06-01, 1:23 pm |
|
"Jessy Martin" < Jessy_Smith79@hotmai
l.com> wrote in message
news:uKVXnMtZFHA.2900@TK2MSFTNGP15.phx.gbl...
> In the SQL Server backup documentation I am seeing some reference to
expire
> date. Expire date has any impact on if we need to restore the database
after
> two years or so.
>
> I am using SQL 2K.
>
> Thanks,
>
> Jessy
>
>
It depends...
The property is used on disk and tape backups. Backup sets which are older
than the expiration date "can be" overwritten by a newer backup. As long
as it has not been overwritten, you should be in good shape.
Rick Sawtell
MCT, MCSD, MCDBA
| |
| Wayne Snyder 2005-06-01, 8:23 pm |
| No, expire date has nothing to do with your ability to restore... It simply
prevents you from over-writing the backup files before the planned
expiration date - ( so noone makes a mistake...)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jessy Martin" < Jessy_Smith79@hotmai
l.com> wrote in message
news:uKVXnMtZFHA.2900@TK2MSFTNGP15.phx.gbl...
> In the SQL Server backup documentation I am seeing some reference to
> expire
> date. Expire date has any impact on if we need to restore the database
> after
> two years or so.
>
> I am using SQL 2K.
>
> Thanks,
>
> Jessy
>
>
|
|
|
|
|