Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Log Shipping Expand / Collapse
Posted Wednesday, April 30, 2014 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 1, 2016 5:41 AM
Points: 7, Visits: 149
Please help me out on below :

I have configured the Log shipping and its working fine.So i want to change the secondary server to primary and primary to secondary.

After successful checking i want to revert the same.

Please share the best approach steps to perform the complete activity

Post #1566414
Posted Wednesday, April 30, 2014 8:31 AM



Group: Administrators
Last Login: Yesterday @ 8:38 AM
Points: 34,366, Visits: 18,586
This article should help you:

It describes the role switching. Note that there's manual work to move the jobs from one to the other, but once they are moved, you can disable them when you revert back.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1566428
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse