HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server Clustering for HA combined with Log Shipping for DR

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
serversqlwithlogforshippingclusteringcombined

Problem

Has anyone implemented SQL Server log shipping in a clustered environment? Are there any issues or things to consider when implementing this scenario?

Solution

In general, log shipping works same way whether SQL server is clustered or not. Only thing you need to use windowsclustername\Share when you copy your logs instead of specifying node names e.g. nodel1\share or node22\share so it works regardless what node your SQL serve is running.

Context

StackExchange Database Administrators Q#16359, answer score: 4

Revisions (0)

No revisions yet.