Hi All,

We have two Online SQL Server. One is used for backup .

How can we make it sure that if one SQL Server is down
then our web site connects to the second SQL server .?

I am planning to write a windows script file that will be
scheduled to run on our web server and keeps checking the
existing of SQL Server 1 after every 10 min by trying to
establish a connection, if it fails it will use the SQL
Server 2 as online database server.

We have one include file that contains the connection
string for Online SQL Server. Either we will try to
dynamically modify the connection string in case of
failure or use
another include file that contains the connection string
for SQL Server 2.

Please advice that if this solution is advisable or what
is the best way to do this task..?
If I go for script file, what is the idea way to check the
existance of SQL Server..? Connection Time Out..?

Note: We are not using SQL Clustering
We have 1 web server and two database server on 3
separate machines.

WAI

Report this post to a moderator

[Please do not post the same question to multiple newsgroups!]
I posted this to your question within .programming:

Are all of your database queries reads, or do you do some
inserts/updates/deletes?
If they modify any data, you will also need a method to turn off the log
shipping so that your backup database is able to be updated.

With that said, I would create a second connection file.
I am not an asp expert, but I have dabbled a little. I do not think tht
you would have to create a separate process to check if your primary
database is up. You should be able to put some validation into the code
that does the database connection....if the primary connection does not
work, use the second connection.

--
Keith, SQL Server MVP


"wai" <wai@hotmail.com> wrote in message
news:e1b901c25994$5b8d3d50$36e
f2ecf@tkmsftngxa12...
> Hi All,
>
> We have two Online SQL Server. One is used for backup .
>
> How can we make it sure that if one SQL Server is down
> then our web site connects to the second SQL server .?
>
> I am planning to write a windows script file that will be
> scheduled to run on our web server and keeps checking the
> existing of SQL Server 1 after every 10 min by trying to
> establish a connection, if it fails it will use the SQL
> Server 2 as online database server.
>
> We have one include file that contains the connection
> string for Online SQL Server. Either we will try to
> dynamically modify the connection string in case of
> failure or use
> another include file that contains the connection string
> for SQL Server 2.
>
> Please advice that if this solution is advisable or what
> is the best way to do this task..?
> If I go for script file, what is the idea way to check the
> existance of SQL Server..? Connection Time Out..?
>
> Note: We are not using SQL Clustering
> We have 1 web server and two database server on 3
> separate machines.
>
> WAI

Report this post to a moderator