<div>
The best solution is a SQL Server cluster so that your app doesn't ahve to deal with this. &nbsp;But ... doing this in the code-behind shouldn't be too hard -- as long as you're just trying to read.<br />
<br />
Somewhere ... maybe actually in a page from which your content pages inherit ... you could put a Connection property.<br />
<br />
This property would:<br />
* Instantiate a SqlConnection, if not already done<br />
* Attempt to connect to the primary DB server<br />
* If that fails, attempt to connect to the second DB server<br />
* Return the connection<br />
<br />
Think that will work for you?<br />
<br />
<br />
<br />

</div>


The best solution is a SQL Server cluster so that your app doesn't ahve to deal with this.  But ... doing this in the code-behind shouldn't be too hard -- as long as you're just trying to read.

Somewhere ... maybe actually in a page from which your content pages inherit ... you could put a Connection property.

This property would:
* Instantiate a SqlConnection, if not already done
* Attempt to connect to the primary DB server
* If that fails, attempt to connect to the second DB server
* Return the connection

Think that will work for you?





<div>
DanielWilson:<br />
Yes...that would work. &nbsp;You have an example?
</div>


DanielWilson:
Yes...that would work.  You have an example?

<div>
Thanks. &nbsp;This put me on the track I needed.
</div>


Thanks.  This put me on the track I needed.

<div>
<div class="content wysiwyg-content">
Hey folks,<br />
&nbsp; I'm using SQL Database as my datasource. &nbsp;What is the best method to look at a different server if server one is down.<br />
<br />
I need to do this in VB code behind inthe Master file I guess.
</div>
</div>


Hey folks,
  I'm using SQL Database as my datasource.  What is the best method to look at a different server if server one is down.

I need to do this in VB code behind inthe Master file I guess.

Server down redirect

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications