Use the below sps to resolve orphaned users. This file will be used to synchronize syslogins to sysusers in secondary when failover occurs. This can be done as following in the command prompt,. You can schedule it as a SQL Job to run specific schedule preferable every 1 hr. Step 4 : Also Disable the log shipping jobs in the primary and secondary servers,once failover occurs. Step 5 : Once the failover occurs the original secondary server is configured as primary and log shipping is again newly configured from this new primary server original secondary to original primary now secondary.
Step 6 : When you once again want to revert to the original state of log shipping i. Script Center. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. The process to switch log shipping roles is detailed at the URL below, is this the process you have followed? Thanks for the detailed query. The LSN chain wast not out of sync.
It did not even come to that. I could not grab any errors related to the process in the windows application logs nor in administrative logs. I'm trying to pin point the relevant event in SQL profiler to trace so i could have a better understanding of what happening under the hood of this Log Shipping process. You must be logged in to reply to this topic.
Login to reply. July 21, at am
0コメント