Forum Discussion
usamawahabkhan
Jul 19, 2024Copper Contributor
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?
- SivertSolemIron ContributorI 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.- null nullCopper ContributorYes 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.