[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

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
0
Stevod2
Asked:
Stevod2
  • 2
1 Solution
 
chapmandewCommented:
Sure
0
 
chapmandewCommented:
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.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now