March 26, 2017 at 12:21 am
Hi All,
A-->prod, B-->DR (LS configured)
after failover B becomes the prod and A becomes the DR(standby/readonly)
during the failback we follow the steps:
stop all LS jobs
backup log with norecovery from B and restore it on A and then enable LS Backup jobs from A.
in the above scenario I forgot to mention the clause with norecovery in B during taillog and restored the log in A (both A and B becomes online)
then 2nd time I again took tail log backup this time specifying WITH NORECOVERY from B and tried restoring on A but got the error:-
the log or differential backup cannot be restored because no files are ready to rollforward.
I don't understand in this case how could I correct my mistake and what exactly happened with the LSN's and why this error?
March 27, 2017 at 1:36 am
There's the main difference between log shipping and db mirroring !
see = "... A log shipping process is always unidirectional ....."
Also have a look at: fail-over-to-a-log-shipping-secondary-sql-server
and Change Roles Between Primary and Secondary Log Shipping Servers
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply