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 |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2002-07-23 : 12:14:12
|
| I am trying to set-up a backup strategy and was confused about what was the best method to go with....Do I do 1 full backup, then schedule incrementals from then on, or do I need to do a full backup every week or so and incrementals?Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-23 : 12:16:26
|
| I'd recommend that latter. You don't want to go too long between full backups. In any case, if you did, you'd end up being left with hundreds of differential backups that might ALL need to be restored, instead of one full backup and only a few differential and/or log backups.Once a week is good for a full backup, but if it doesn't take long to do, you should do full backups as often as possible. |
 |
|
|
interclubs
Yak Posting Veteran
63 Posts |
Posted - 2002-07-23 : 13:36:19
|
| Is there a reason to keep the old full backups, or can I delete them once I get the new weekly one, otherwise I will run out of space quickly. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-23 : 13:38:04
|
| No, there's no need to keep an old(er) full backup, unless you need to restore data that was deleted before the last full backup. In that case, you'd use an archive table/database that is separate from your working database. |
|
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-24 : 11:15:15
|
| My understanding is as follows:When full backups and differential backups are being taken and it comes time to restore, I believe you only need the full backup and the "latest" differential. It is not required to restore other intervening differential backups.Please correct me if I am under a misunderstanding.Thanks solart |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-24 : 11:20:10
|
| Yes, that's true. I was thinking of transaction log backups as part of this procedure. After the full and differential backups are restored, any and all log backups must be restored in the correct order before the database is fully restored to a point-in-time state. |
|
|
|
|
|
|
|
|
Backup Strategies