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 |
|
AnAgSh
Starting Member
18 Posts |
 Posted - 2007-11-08 : 02:42:40
|
| If we do TxLog backup during the FullBackup, will this cause any problem during the Restore operation? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-08 : 05:02:57
|
| the full backup will always be such that a database will be in a consistent transactional state.it will also contain enough of the transaction log to rollback any pending transactions. these will be then included in full in your transaction log.so you'll be ok._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-08 : 13:54:11
|
| "If we do TxLog backup during the FullBackup,"In addition to what Spirit said: If the Full Backup starts first, and then the TLog backup starts, the running Full backup will cause the TLog backup to "wait" until the Full backup has finished, and then "resume" |
|
|
|
AnAgSh
Starting Member
18 Posts |
Posted - 2007-11-08 : 23:01:27
|
| Thank you guys for the details. |
|
|
|
|
|
|
TxLog + Full = Restore