Solved

How to change log shipping roles?

Posted on 2010-11-30
5
597 Views
Last Modified: 2012-05-10
I set up log shipping on database LogShippingDB on two servers - ServerA and ServerB. ServerA is primary and ServerB is secondary in standby mode. It works well. I am trying to change roles. So ServerB will be primary and ServerA will be secondary in standby mode.
- Do I need to re-configure log shipping when ServerB will be primary?
- If I disable old log shipping setting on ServerA, it will remove all log shipping jobs set up before. If I would like to keep all setting. What should I do? Rename the database LogShippingDB on ServerA?
- What's are good steps for changing old primary to secondary in standby mode and changing old secondary to primary?
Thanks!
0
Comment
Question by:luyan
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34240491
Havnt tested it but you may be able to do a tail log backup from the primary and then restore it to the secondary with recovery. Although this is manual and you will have to remove and add log shipping again to ensure the job are copy and restoring in the right direction.

To be honest, if you want to be able to switch back and forth it would probably be a better idea to use mirroring.
0
 

Author Comment

by:luyan
ID: 34242185
Thanks EvilPostIT for your answer! Do you have any good document for configuring and using mirroring?
Thanks!
0
 

Author Comment

by:luyan
ID: 34293862
When something wrong on ServerA, I put the secondary node ServerB as the primary. When the issue is fixed, what should I do to change it back- ServerA as primary node, and ServerB as secondary node again? And put ServerB as standby database again?
Thanks!
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34299256
Is it still mirroring? or is the mirror broken.

Appologies about not replying before. Must have missed that notification.
0
 

Author Comment

by:luyan
ID: 34301928
Thanks!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question