473,287 Members | 1,689 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

referencing a failover datasource if primary DB server is down?

My scenario is that I have two webservers/database servers that I'm trying
to make redundant in terms of filesystems, web services, and database
services:
+ filesystems are replicated using server 2003 R2
+ web services are made redundant using NLB
+ databases are mirrored via SQL Server 2005 database mirroring.

I have ASP.NET and ASP applications that consult the database. These
applications are being mirrored by virtue of the fact that the filesystems
between the two servers are being mirrored. What I need to figure out is the
cleanest way to set up things so that my apps will initially try to
reference database server "A" for its data needs, and if that doesn't work,
to attempt to contact database server "B". Remember that the databases will
be exactly mirrored on both boxes, so no aspect of the DB schema should
change.

Is this capability built into any aspect of ASP.NET's data provider model?
For any fellow Classic ASP dinosaurs (freshly paid from MSFT's "Office has
evolved..have you" campaign :), can someone suggest a clean workaround in
classic ASP?

Thanks,

Ken Fine
University of Washington
May 16 '06 #1
1 2546
Googling around a bit, I found the answer I wanted for ASP.NET. Still trying
to figure out something clean and automatic in classic ASP. See here for
information on ASP.NET:

The .NET Data Provider for SQL Server provides implicit support for
database mirroring, so that the developer does not need to take any action
or write any code once it has been configured for a SQL Server 2005
database. In addition, the SqlConnection object supports supplying the name
of a failover partner server in the ConnectionString.

http://msdn2.microsoft.com/en-us/library/5h52hef8.aspx

If anyone has good ideas about how to hack something together for classic
ASP, please suggest. I'd like the failover to be automatic.

-KF

<ke*****@nospam.nospam> wrote in message
news:O2**************@TK2MSFTNGP04.phx.gbl...
My scenario is that I have two webservers/database servers that I'm trying
to make redundant in terms of filesystems, web services, and database
services:
+ filesystems are replicated using server 2003 R2
+ web services are made redundant using NLB
+ databases are mirrored via SQL Server 2005 database mirroring.

I have ASP.NET and ASP applications that consult the database. These
applications are being mirrored by virtue of the fact that the filesystems
between the two servers are being mirrored. What I need to figure out is
the cleanest way to set up things so that my apps will initially try to
reference database server "A" for its data needs, and if that doesn't
work, to attempt to contact database server "B". Remember that the
databases will be exactly mirrored on both boxes, so no aspect of the DB
schema should change.

Is this capability built into any aspect of ASP.NET's data provider model?
For any fellow Classic ASP dinosaurs (freshly paid from MSFT's "Office has
evolved..have you" campaign :), can someone suggest a clean workaround in
classic ASP?

Thanks,

Ken Fine
University of Washington

May 16 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: paul | last post by:
Hi, i'd like to know how to implement an automatic failover with HADR. I've configured 2 databases, one primary and the other standby. Everything works ok (replciation and takeover). But if i...
1
by: WildHare | last post by:
I am looking for documentation on state server failover. There is a microsoft article which sort of talks about protecting against a failed state server by using SQL server...but it about as clear...
0
by: david paul clark | last post by:
all can someone point me to some docs on best practices for setting up the out of proc services for failover. right now we have an out of process session service running. if it goes down, what is...
6
by: kavallin | last post by:
2 servers with solaris,veritas cluster and DB2 UDB ESE v8.1 with fixp10. ON the primary db2 server did I create 2 db2 instances and the admin instance. It is possible to start both db2 instances...
1
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to...
1
by: Mark D Powell | last post by:
I have a production failover cluster running SQL Server 2000 at SP3 that I want to upgrade to SP4. I do not have a test failover cluster to test with so I need the install on the primary server to...
2
by: PaulAtIPS | last post by:
Good Afternoon, I hope that this message is in the right forum area. We have 18 servers both on the DMZ and internal. The problem that I am having is getting the Domain Controller(DC) on my DMZ...
0
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover...
8
by: Guy Macon | last post by:
How to increase web server uptime with DNS failover: For illustration, let's start with some really bad hosting... Find four free web hosts that are each 90% reliable -- in other words they...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.