Re: Choosing correct high availability setup
- From: "Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Jun 2007 09:39:24 -0500
Never do both on the same box, read this -
http://msmvps.com/blogs/clusterhelp/archive/2006/02/17/84035.aspx.
Server Clustering with make the entire node HA, SQL mirroring will make that
database HA. Which does your customer require?
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Marty Shifflett" <MartyShifflett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:F03EC295-F9C8-4602-B787-BFBCC5841E48@xxxxxxxxxxxxxxxx
I have a client that wants me to start hosting their SQL and IIS for them.
They want to have the ability to have a "hot spare" in case the primary
SQL
server fails. I have read and read until my eyes hurt about clustering
and
mirroring and I am getting more confused on how to proceed.
My first question is, should I even be using IIS on the SQL box at all?
They have a web interface that gets it data from SQL.
My second question is, if I host their web site on a separate IIS box is
there any reason that I shouldn't go with database mirroring instead of
any
other option?
Thanks for any help you can provide.
Marty
.
- Prev by Date: Re: How to: Remove Physical Disk from SQL Cluster Group (If possible)
- Next by Date: Re: Truly High Available?
- Previous by thread: How to: Remove Physical Disk from SQL Cluster Group (If possible)
- Next by thread: Re: Choosing correct high availability setup
- Index(es):
Relevant Pages
|
