Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 639
  • Last Modified:

How to change log shipping roles?

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
luyan
Asked:
luyan
  • 3
  • 2
1 Solution
 
EvilPostItCommented:
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
 
luyanAuthor Commented:
Thanks EvilPostIT for your answer! Do you have any good document for configuring and using mirroring?
Thanks!
0
 
luyanAuthor Commented:
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
 
EvilPostItCommented:
Is it still mirroring? or is the mirror broken.

Appologies about not replying before. Must have missed that notification.
0
 
luyanAuthor Commented:
Thanks!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now