Backup Set will expire - Backups
-
Hi All,
Hope all are doing well!
I got a question regarding Backupset will expire: Example my Backup was taken on 05-Aug-2016 and Expire date is given on 08-Aug2016 i.e. backup set expired,
01. After Backup Set expires can we use backup to restore a database if backup is not purged/deleted?
02. If Backup Set Expired and we want to store that backup file in another drive for next one year will it be possible/guarantee that we can restore and get data after one year?
03. Backupset overwrites the backups if we use the option overwrite, if i put append and if i had given an expiration date what will happen?
04. Overwrite means it will overwrite the metadata or file?
I have a bit confusion, i have a maintenance plan which take regular full backup and set expiration to 14 days, now i want archive some data and keep the backup which was taken from maintenance plan where i am not allowed to take copy_only backup, so can i use the backup and store it one year if expiration is declared for a backup.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Save a tree... Please don't waste paper unless you really need to!
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
01. After Backup Set expires can we use backup to restore a database if backup is not purged/deleted?
Answer - The EXPIREDATE option has no effect on whether you can restore a database.
02. If Backup Set Expired and we want to store that backup file in another drive for next one year will it be possible/guarantee that we can restore and get data after one year?
Answer - See #1 and as long as the backup file is not overwritten or deleted
03. Backupset overwrites the backups if we use the option overwrite (or init), if i put append and if i had given an expiration date what will happen?
Answer - If you back up your database to an existing file, the default setting (NOINIT) is to append that backup to the file. If you explicitly use INIT, however, it will overwrite the backup file and delete any existing backups, unless the EXPIREDATE value is a date sometime in the future.
04. Overwrite means it will overwrite the metadata or file?
Answer - Backup File. The metadata (data about the backup in system tables should still be present).
-
Thanks much, As i have to archive the database i need to store the backup of database on other server for next one year, i was in a confusion whether now i can store a backupset expire backup can work for restore.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply