Setting log shipping in AlwaysOn environment

Question

Hello everyone,

We have 4 Servers which have SQL SERVER 2012 and "AlwaysOn" have been enabled on all 4 servers:

Server1,Server2,Server3,Server4

Server1 is the Primary node and thr rest are secondaries. There is a Sync relation between Server1 and Server2 and also there is aSync relation between Server1 and Server3 & Server4.

Is it possible to setup  log shipping from Server2 & Server3(secondaries) to two new servers?Does this have any problem?

Thanks

---

A.G

Answer 1

Hi there,

If your databases are not part of Availability group then it is fine. you can do it.

for more information read the "Availability Replicas" section

http://msdn.microsoft.com/en-us/library/ff877884.aspx

thanks

kumar

Answer 2

LogShipping per definition is related to a database, so if your DB is in an Availability Group that spans all four servers then from the concept you have to setup LogShipping from the primary instance (Server 1). The key though is that using the "Backup on Secondary" feature that AlwaysOn Availability Groups bring you you can easily get SQL Server to do the actual work of the LogShipping on either Server2 or Server3.

The one thing to understand though is: You have ONE Logshipping setup that can then have TWO destinations. (Your two new servers.) You do not have seperate logshipps for those two destinations.