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 |
|
JohnDeere
Posting Yak Master
191 Posts |
 Posted - 2003-09-18 : 14:45:58
|
| I have always scheduled my transaction log backups to not run during my full or differential database backups.I was asked today if the log backups could be scheduled to run during the full and differential backups of the database.If log backups can be done during a full or differential backupwould they apply to the current full/differential backup or the previous full/differential backup?Thanks. Lance Harra |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-18 : 15:36:10
|
| Yes they can run simultaneously. The transaction log would be applied to the previous full backup if the current one hasn't been completed when the transaction log backup kicks off. It'll error out if you pick the wrong backup.Tara |
 |
|
|
|
|
|
Transaction log backups during a database backup