SQL Server Performance Forum – Threads Archive
role reversal in logshippingHi,
I built logshipping,then i have done role change ie i made my
secondary server as production server .I have done some server updation
at my production server.Now i have to make my old production server
to be the primary server and the existing primary server,which is old secondary server
to secondary server.In simple,i have made my secondary server to primary server,fixed the updation to the production server,now time to make my production server again back in to action as primary server,what should i do,where can i get the apt information.Microsoft site says you have to reset logshipping from the scratch,is it the only way or can i get apt information. THIRUVENGADAM
Have you tried to follow role changes again making current secondary as (back to) primary.
Follow the information provided on your other linkhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2288 _________
Also refer thru this technethttp://www.microsoft.com/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp link. _________
I have done logshipping.Then tried role change,it sucessfully changed the role.After role change the two jobs responsible for logshipping namely
log shipping restore
Now if i want to make my primay server ie the original production server in to action again.What is the easiest way to do that. I tired role reversal,just like role change,it is not working.
Now through my old secondary serever users have added data and it takes say around 3 hours for me to bring back my original production server.
Now i have to make my original production server in to action
what is the easiest way to do that.
Its not working… means what was the error or any information from SQLAgent log and SQL Server error log will help. The only way of role reversal is the way you reverse the role change earlier. _________