SQL Server Performance

Changeing logshipping server

Discussion in 'SQL Server 2005 Log Shipping' started by contactjimmyus, Feb 20, 2008.

  1. contactjimmyus Member

    i have logshipping configured on the servers and wish to change the primary to secondory and secondary to primary .Can any one explain the detailed steps involved in the process Thanks in advance
    contactjimmyus, Feb 20, 2008
    #2

  2. ndinakar Member

    I think you have to remove logshipping and re-set it up....
    ndinakar, Feb 20, 2008
    #3

  3. satya Moderator

    Do you want to swap the servernames between the sites or simply run primary from other site having secondary on the current primary server?
    Perform a failover if its not specific to the servername changes.
    satya, Feb 21, 2008
    #4

  4. marrow New Member

    When I am using SQL Server 2000, I just have to detach the read only DB for log shipping secondary server and the re attach it. but in this case our developer has to change the connection string to the new server name.
    marrow, Apr 19, 2008
    #5

Share This Page