SQL Server Performance

Changeing logshipping server

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

  1. 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
  2. ndinakar Member

    I think you have to remove logshipping and re-set it up....
  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.
  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.

Share This Page