• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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