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