Forum Discussion

usamawahabkhan's avatar
usamawahabkhan
Copper Contributor
Jul 19, 2024

Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database

I hope this message finds you well.

I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) database. As they do not have an enterprise license, we need to use the standard edition, which necessitates an FCI for High Availability (HA).

We are considering configuring log shipping for DR purposes. However, I have come across some information suggesting that log shipping may not be supported with an FCI. Could anyone confirm whether this is the case? If it is supported, are there any specific considerations or best practices we should be aware of?

  • SivertSolem's avatar
    SivertSolem
    Iron Contributor
    I am not aware of Log shipping and FCI being incompatible.
    I did see the page about Log shipping warning about compatibility issues with Availability Groups though.

    That could be a point of confusion, as the full name for both solutions can be similar.
    - Always On Failover Clustered Instance
    - Always On Availability Group

    In my experience, both of these have been shortened to just Always On at some point or other on the open internet.
    ---
    From what I can understand, there should be no issues with Log Shipping from a clustered instance to elsewhere (even a different FCI), as long as the transaction log backups are accessible at the same network address independent of which node is currently the active node.

Resources