Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
calvin464
Starting Member
11 Posts |
 Posted - 2006-09-13 : 19:08:16
|
| Hi All,Has anyone setup SQL Server 2005 with clustering and data mirroring combined? We currently have a SQL Server 2000 cluster which we will upgrade to 2005 at our current site and would like to setup another cluster at our data center location and configure data mirroring between the two. I would like to know what would be invovled and/or is there a better solution. I looked into mirroring alone but if the princpal and witness servers at one of the location were to go down, the database would be unaccessible. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-13 : 19:12:42
|
Yes we have this setup. This particular cluster is a 4 node cluster running Win2k3 64-bit with 11 instances of SQL Server 2005. It's running in production as of a few weeks ago. Our disaster recovery site is located about 300 miles away. I highly recommend database mirroring as a disaster recovery solution. We were using log shipping for 2000, but we'll never look back. quote:
I looked into mirroring alone but if the princpal and witness servers at one of the location were to go down, the database would be unaccessible.
Where did you find this information?Tara Kizer |
 |
|
|
calvin464
Starting Member
11 Posts |
Posted - 2006-09-13 : 20:35:28
|
| Hi Tara,Are you referring to whether this was true or not regarding the statement: "I looked into mirroring alone but if the princpal and witness servers at one of the location were to go down, the database would be unaccessible. "This was in reference to a non clustered solution where we would have a principal, witness, and mirror. Say the 2 boxes, principal and witness on our site were down due to hardware, how would the mirror in the remote location take over the db function?Back to the clustering and mirroring you have setup in your environment, can you be more specific on how this is setup or can provide a link that specifically talks about how the network and systems needs to be setup?Thanks in advance! |
|
|
|
|
|
|
Combining Clustering and Mirroring in SQL 2005