Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jspatz
Starting Member
15 Posts |
 Posted - 2009-06-18 : 11:25:36
|
| This may be a stupid question .. but .. What exactly is an "Expired BackUp Set" By definition it means the expiredate is when the backup set will be expired and overwritten .. but I am not 100% sure what that means for me .. We take daily backups and tran logs backups that are written to individual files that are date stamped. We store 7 days on disk, and back them up to tape.. where they are saved for 30 days. If the backup set is older then say 7 days, which is what it is set to in the maint plan .. what does that do to my backups on tape.. can I not recover from them if I have problems? I think I just need some clarity .. Thanks!! |
|
|
drkusnadi
Starting Member
2 Posts |
Posted - 2009-06-18 : 19:14:41
|
| "These options only prevent SQL Server from overwriting a file. Tapes can be erased using other methods, and disk files can be deleted through the operating system. For more information about expiration verification, see SKIP and FORMAT in this topic. ""To ignore the expiration date, use the SKIP option."from: http://msdn.microsoft.com/en-us/library/ms186865.aspx |
 |
|
|
|
|
|
Expired BackUp Sets question