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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-06-26 : 07:26:43
|
| 1.if i backup log, is backup uncomitted transaction?2. if yes then if my last backup log have a uncommited transaction, can i restore it?6:00 full backup7:00 log backup8:00 log back up (have uncomiitted backup)8:49 i have distaster.can i restore the last backup with uncomitted transaction? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-27 : 20:28:05
|
Uncommitted Transaction will rollback.You can't restore it.You can use Backup log with No_Truncate to get latest committed Transaction(Assuming Database is online) and Restore all Logs along with Full. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-06-29 : 01:30:13
|
| do you mean "Backup log with No_Truncate"it is same Back up the tail of the log, and leave the database in the restoring state?if not wht i need this option? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-29 : 07:58:00
|
| Kinda. That option actually translated (if I recall) into this statementBACKUP LOG ... WITH no_truncate, norecovery--Gail ShawSQL Server MVP |
|
|
|
|
|
|
last log