February 20, 2004 at 12:10 pm
I plan to use SQL SErver 2k EE for logshipping on a couple of sql server instances. Does any one know how to redirect clients from the primary server to the secondary server. eg, if the primary server is SQLP and the secondary server is SQLS, then how do clients use SQLS when SQLP fails? Also, how should this be done with the secondary service is a named instance of SQL Server. Using SQL2K EE.
February 21, 2004 at 9:01 pm
You probably can change the DNS entry for the SQLP to point to SQLS. (dns alias record I believe..)
Now if the secondary server is a named alias, that could be trickey.. Do the clients connect directly to the SQL server or do they use web / app server. Then you can just change the app/web server to go to the new server and you are done.. Other wise, I cannot think of any way (for names instances..)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply