473,320 Members | 1,926 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,320 software developers and data experts.

Fail over - DNS change

Hi,

In case of failover to standby server, what is theest way to redirect
client applications to new server?
1) DNS name change -- not viable due to Caching issue.

IS there any alternate like Oracle's onames/LDAP for resolving name
with sql server?

Can use Sever alias?

Thanks
Jul 20 '05 #1
6 1977
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Hi,

In case of failover to standby server, what is theest way to redirect
client applications to new server?
1) DNS name change -- not viable due to Caching issue.

IS there any alternate like Oracle's onames/LDAP for resolving name
with sql server?

Can use Sever alias?

Thanks


There's no equivalent to Oracle's naming solutions, since MSSQL uses
the operating system for name resolution. If you can't use DNS, then
you would have to look at modifying connection strings or ODBC DSNs in
your applications. This is easier for some types of applications than
others, of course.

Simon
Jul 20 '05 #2
Please share any other recommendations.

sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Hi,

In case of failover to standby server, what is theest way to redirect
client applications to new server?
1) DNS name change -- not viable due to Caching issue.

IS there any alternate like Oracle's onames/LDAP for resolving name
with sql server?

Can use Sever alias?

Thanks


There's no equivalent to Oracle's naming solutions, since MSSQL uses
the operating system for name resolution. If you can't use DNS, then
you would have to look at modifying connection strings or ODBC DSNs in
your applications. This is easier for some types of applications than
others, of course.

Simon

Jul 20 '05 #3
Sinon,

Thanks for reply. How does it uses OS for name resolution in case of
multiple instances? Could we use multiple IP address feature of sql
2000 for fail over purpose? Using virtual IP, but without using
clustering.
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Hi,

In case of failover to standby server, what is theest way to redirect
client applications to new server?
1) DNS name change -- not viable due to Caching issue.

IS there any alternate like Oracle's onames/LDAP for resolving name
with sql server?

Can use Sever alias?

Thanks


There's no equivalent to Oracle's naming solutions, since MSSQL uses
the operating system for name resolution. If you can't use DNS, then
you would have to look at modifying connection strings or ODBC DSNs in
your applications. This is easier for some types of applications than
others, of course.

Simon

Jul 20 '05 #4
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Sinon,

Thanks for reply. How does it uses OS for name resolution in case of
multiple instances? Could we use multiple IP address feature of sql
2000 for fail over purpose? Using virtual IP, but without using
clustering.


<snip>

The client resolves the server part of the instance name, then
connects to port 1434 to get back a list of instances and the ports
they listen on; it can then connect to the correct port for the
instance you requested. You can specify these ports explicitly using
the MSSQL Server Network Utility if you want to.

Clustering is the standard way to implement failover with MSSQL -
multiple instances aren't useful for high availability. You can check
these resources for more details:

http://www.microsoft.com/sql/techinf...ailability.asp
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx

I'm not sure why you want to avoid clustering - if you have a business
need for any sort of high availability solution, then you have to make
sure you get the correct resources you need for that.

Simon
Jul 20 '05 #5
Our vendor application (web based) doesn't support clustering. What
are the disadvantages of using NLB for failover? I've read it is not
advisable to use NLB for critical DB failovers. Is it true?
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Sinon,

Thanks for reply. How does it uses OS for name resolution in case of
multiple instances? Could we use multiple IP address feature of sql
2000 for fail over purpose? Using virtual IP, but without using
clustering.


<snip>

The client resolves the server part of the instance name, then
connects to port 1434 to get back a list of instances and the ports
they listen on; it can then connect to the correct port for the
instance you requested. You can specify these ports explicitly using
the MSSQL Server Network Utility if you want to.

Clustering is the standard way to implement failover with MSSQL -
multiple instances aren't useful for high availability. You can check
these resources for more details:

http://www.microsoft.com/sql/techinf...ailability.asp
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx

I'm not sure why you want to avoid clustering - if you have a business
need for any sort of high availability solution, then you have to make
sure you get the correct resources you need for that.

Simon

Jul 20 '05 #6
ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>...
Our vendor application (web based) doesn't support clustering. What
are the disadvantages of using NLB for failover? I've read it is not
advisable to use NLB for critical DB failovers. Is it true?


<snip>

I have no idea, since I've never used NLB myself. See here:

http://www.microsoft.com/technet/pro...y/hasog04.mspx

Simon
Jul 20 '05 #7

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

Similar topics

1
by: rayt | last post by:
I’m relatively new to XSLT and must admit I’m finding it refreshing, but every now and again something comes along which floors me. Maybe it’s the old imperative language background that is hard to...
23
by: | last post by:
hi i try to malloc 2G size mem . so i wirte code like that. it failt in freebsd 5.3 and win2k what's bug in my code ? how can i change it ? thank all :) benjiam
6
by: Agnes | last post by:
I can show the login.aspx page in my window2003 IIS6 . However, after I click the "ok" buttonm it said The 'VfpOleDB.1' provider is not registered on the local machine. (1)I can run the...
0
by: KR | last post by:
Hi, I have created a For Each Loop Containers to loop through the files in the directory and process them. If it does not find any files in the directory it should fail the package. However it...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.