Post reply

connection time out failover in Sql Server 2005

  • January 29, 2009 at 6:44 am

    #196663

    Hi,

    I am Oracle 10g dba and configured Multimaster Replication in oracle. Now i am trying to do it in sql server 2005. Which i have done successfully . In Oracle we have a file like tnsnames.ora in which we define connection time out feature using which if connection on one server fails it will automatically transferred to another server. Do we have any facility in sql server 2005 so that if my one server fails my connection got transferred to the second replication database.

    Thanks

    Umesh

  • January 30, 2009 at 5:15 am

    #935416

    No - well not as far as I am aware. There could be some 3rd party tool to manage this?

    I suppose you could have an alternate connection string in the application config files which it could use in the event of timeouts.

  • January 30, 2009 at 6:37 am

    #935476

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply