• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 4654 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL lite speed backup when there are Two primary logshipping servers

dsagar799
over 7 years ago

I have a setup like Server A (DB mirroring Principle) server B (DB mirroring mirror role) configured in sync mode and Server C which is configured as logshipping secondary with Server A and Server B as logshipping primary servers. So can the lite speed detect which server is primary incase of failover of Mirroring instances and take the backup and recover if needed?

example of setup is https://msdn.microsoft.com/en-us/library/ms187016.aspx

 

 

  • 0 over 7 years ago

    At first glance I would say...no... as this is a native log shipping setup. The only primary databases Litespeed looks for (and takes into account for how it performs a backup) are those that belong to an always on availability group .But please open a support case so we can get more details on your setup.

     

    Thanks