Link to home
Start Free TrialLog in
Avatar of Stevod2
Stevod2

asked on

Can I use SQL Server Failover cluster and Log Shipping together

I have two servers in a primary data centre which I need to fail-over for each other using SQL Server Fail-over Cluster in Single Instance mode (on a shared disk array) .

In addition, I need to log ship to a secondary data centre, where the data is backed up to tape from the secondary database in the log shipment.

Will the Fail-over servers continue to provide log shipment to the secondary, transparently after a fail-over?

Thanks,
Stevod
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It would work the same way as if it were not clustered.  Log shipping really doesn't care if the underlying db is a shared resource.