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 |
|
Zoroaster
Aged Yak Warrior
702 Posts |
 Posted - 2008-01-25 : 18:11:37
|
All, I am new to log shipping and I am troubleshooting an issue with it. Basically somebody restored a backup from a day ago on the primary server, now the load is failing on the destination (obviously). I read that I should disable the jobs and backup and restore to the destination server to get it going again. I have some questions on this though, since the destination is a standby I read that I need to use the WITH STANDBY clause and specify a standby file name to use. Where do I find out the standby file name to use here and also is this the only way to get it back in synch? Thanks in advance.
Future guru in the making. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-25 : 23:14:01
|
| Checked log shipping properties? |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2008-01-25 : 23:46:18
|
Yes, the error I found in the history table was that the LSN was too early or something like that.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-26 : 00:01:44
|
| I mean did you find standby file in log shipping properties. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2008-01-26 : 01:01:19
|
quote:
Originally posted by rmiao
I mean did you find standby file in log shipping properties.
I wasn't quite sure where to look for it, I am not connected now so I can't tell.
Future guru in the making. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-26 : 01:32:38
|
| The only way to get it back in sync is to get the secondary database back to the exact same restore point. Log shipping is not a smart technology.Do you know exactly which tlog backup file was successfully restored on the secondary database? If not, then you must rebuild log shipping again from scratch.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Log Shipping