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 |
|
scuzymoto
Starting Member
17 Posts |
 Posted - 2008-02-01 : 13:14:52
|
| I have a backup plan that begins with a weekly full backup and then a nightly transactionlog backup. If mid week I perform a full backup to restore on another server does that affect the log backups of the scheduled plan? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-01 : 14:27:59
|
| Log backups after your full backups in midweek will be valid. |
 |
|
|
scuzymoto
Starting Member
17 Posts |
Posted - 2008-02-01 : 14:56:50
|
| Valid for the midweek backup or valid for the regularly scheduled backup? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-01 : 23:25:40
|
| >> If mid week I perform a full backup to restore on another server does that affect the log backups of the scheduled plan?That will not affect log backup. But I'd rather do full backup daily and log backup much more often. |
|
|
|
|
|
|
Backup Plans and Random Backups