SQL Server Performance

Loghipiing

Discussion in 'Getting Started' started by glnprvn, Sep 29, 2009.

  1. glnprvn New Member

    how to redirect the clients to the application after failover to secondary server in logshipping sqlserver 2005
    i got this question in some interview "how to connect to the application after failover to secondary server in logshipping"
    thanks in advance
  2. ndinakar Member

    There isnt any automatic way. Clients need to re-establish connection to the new server.
  3. satya Moderator

    Welcome to the forums.
    Appreciate your Q here stating this is something you got from interview question, as suggested this has to be manually configured at Application level to take care of connectivity. Also I would suggest to take a look at Books ONline for SQL Server where you can use as first hand resource to get good information in hand.

Share This Page