Re: Choosing correct high availability setup

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

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • 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: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)