Re: Choosing correct high availability setup

Yes NLB (Network Load Balancing), IIS is not made for Server Clustering, and
won't be supported/allowed with Windows Server 2008 Failover Clustering.

No matter how you do your SQL, IIS will need to know the instance name to
connect.

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:1429702D-83EF-4E83-B2DD-0C127B41DAC8@xxxxxxxxxxxxxxxx
NLB?

If I use clustering for the backend, will the web server be able to keep
serving the data from the SQL database to the web interface in the case of
a
disaster? The web site will be looking for a specific instance of SQL
correct?

"Rodney R. Fournier [MVP]" wrote:

Got it, use NLB for the IIS servers, Server Clustering for the backend :)

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:ECAE918E-4B1E-4339-A4CA-7F5752DC6768@xxxxxxxxxxxxxxxx
Well that is what I had always thought, but you see more and more
people
consolidating these functions.

Basically there will be an Access database that arrives via FTP at the
web
server, the SQL server will pick it up from a shared drive and import
it.
That will happen about every 15 minutes or so. The same web server
will
host
a site that the client can access to see real time data that it pulls
from
the SQL server. The only snag is that if the primary SQL server goes
down
for some reason, IIS will not know that it has to get that data from
the
backup server if I am using only mirroring.



"Rodney R. Fournier [MVP]" wrote:

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








.

Relevant Pages

  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to install service pack 3a on a failover cluster
    ... MVP - Windows Server - Clustering ... We have two instances of sql running so I ... > the second node and rebooted the first node. ...
    (microsoft.public.sqlserver.clustering)