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 |
|
ggarza75
Yak Posting Veteran
50 Posts |
 Posted - 2008-08-20 : 12:26:04
|
| I need a little assistance here. I know how to restore a database using SQLSafe from a full backup. My question is this, how can I restore database and then restore the transaction logs afterwards.When I restore a database, I leave it at Non-operational, but able to restore additional transaction logs.From this point, I'm lost.Can anyone help? Thanks a bunch. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-20 : 12:34:54
|
| Using that option is correct, so it's using WITH NORECOVERY. Now you just need to tell it to apply the transaction log backup. On the very last tlog backup you want to apply, switch the option so that it knows you have no other tlog backups to apply. Then it'll use WITH RECOVERY.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Restoring Transaction Logs (SQLSafe Involved)