Wednesday, January 23, 2013 6:55 PM
We have 4 Servers which have SQL SERVER 2012 and "AlwaysOn" have been enabled on all 4 servers:
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?
Thursday, January 24, 2013 3:44 AM
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
Monday, January 28, 2013 9:19 AM
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.