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. wingman
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...