Forum Discussion
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) ...
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.
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.
- Yes SivertSolm you are correct FCI will support another DR solutions as Logshipping also.
. (FCIs are often combined with another availability method, such as an AG or log shipping, to have redundant copies of databases. The additional method deployed should use physically separate storage from the FCI) https://learn.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver16 please go through here.
