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 |
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-11 : 05:43:01
|
I Configured a Log Shipping With a Standby Mode in Our Site.It's Working fine.I took a log backup Manually.After Restore Job was Failed in Secondary Server.So How Resolve the Problem.--Ragu ThangavelJunier Sql Server DBA |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-03-11 : 13:02:48
|
You broke it when you took the tlog backup manually. To get it back in sync, you'll have to apply your manual tlog backup to the secondary server. Log shipping should be able to get back in sync after that. Do not take any tlog backups outside of the log shipping maintenance plan to avoid this problem in the future. As long as you use the maintenance plan, it will keep in sync.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-11 : 23:56:50
|
Thank you very much fro your reply.--Ragu ThangavelJunier Sql Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|