• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

SQL 2008 R2 - Getting Started with Clustering and Mirroring

I'm getting started with a new SQL environment. My details are below:

Environment:

Primary and secondary site
SQL 2008 R2 Standard
Windows Server 2012 R2 Standard
No Shared Storage
Two SQL Servers total. Virtualized in two separate locations

It appears the solution based on my budget and needs one involving clustering of two SQL servers, and then mirroring my three databases.

I'm doing a fresh install of windows. VMware and VPN are already in place.

Would you point me to a good reference to get started with the process or outline the high level tasks?
0
First Last
Asked:
First Last
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How do you intend to create a cluster without shared storage? Or you are thinking in geo cluster? Then you need to find a way to replicate storage from on location to the other one.
Also, you don't need a cluster to mirror databases.

References:
Windows geo clustering
SQL Server Mirroring
0
 
First LastAuthor Commented:
SQL 2008 R2 with SP3 utilizing database mirrioring on a Windows Server 2012 R2 Cluster w/o shared storage is difficult at best. I've decided to no go with clustering or mirroring.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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