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 |
|
R
Constraint Violating Yak Guru
328 Posts |
 Posted - 2008-10-15 : 08:17:27
|
Hi there.I've recently created a maintenance plan to perform backups, with the following schedule:1) Weekly Full2) Daily Differential3) Hourly Transaction LogBecause I'm new to this, I set the expiry period for each backup to be 90 days. I am correct in thinking however that I could have actually set the hourly transaction log backup file to expire after 7 days? Someone told me I can delete log backups created before a full backup, but wanted to check first!Thanks  |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 10:31:15
|
| Full backup captures everything.Differential Backup captures everything after Full backup is done.Yes,You can delete log backups done before Full backup is taken. |
 |
|
|
R
Constraint Violating Yak Guru
328 Posts |
Posted - 2008-10-16 : 03:59:29
|
| Great. Thanks for clarifying that point. |
|
|
|
|
|
|
Scheduled backup question