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 |
|
arturopw
Starting Member
2 Posts |
 Posted - 2010-03-28 : 21:19:20
|
| Hi everyone,I'm a little new with log shipping implementation. I have a full backup of my target db and then a tran log backup after that. I want to restore both of those to a secondary server and leave the server in stand-by mode. I restored the full just fine, and it created the ROLLBACK_UNDO.BAK file. My question is how do I apply that as I restore the tran log after that. When I attempted it went to create the the ROLLBACK_UNDO.BAK file again (with the same name). Shouldn't the orig one be applied during the tran log restore and then a new file get created that gets applied by the log shipping once that starts running?Thanks in advance,Arturo |
|
|
arturopw
Starting Member
2 Posts |
Posted - 2010-03-29 : 10:18:04
|
| I see it was a silly question now. All but the last restores should be RESTORE WITH NO RECOVERY and the last restore can be the one with RESTORE WITH STANDBY. |
 |
|
|
|
|
|
Set up Log Shipping off full and tran backups