SQL Server Performance

Move the logshiping db from a secondary server to another server

Discussion in 'SQL Server 2005 Log Shipping' started by WingSzeto, Nov 19, 2008.

  1. WingSzeto Member

    I am currently doing logshipping from primary server A to secondary server B. Now we are deploying a new server C to replace server B. Is there a way to move the logshipped DB and its transacation logs in server B to server C so the logshipping would continue to work without any redo of logshipping? The reason for this quesiton is because server B (and the new server C) is in a different city compared to server A. I don't want to transfer the entire full backup of the db in server A if there is a better way to do it.
  2. MohammedU New Member

    I don't think there is any way of avoiding the full db restore?
    Are you using builtin or custom log shipping?
    In either case you have to run the full restore...

Share This Page