Sql Server currently has LiteSpeed Log Shipping version 4.8.4, what are the correct steps to upgrade Log Shipping to LiteSpeed version 6.x?
WORKAROUND:
You will not have to re-init or resync after upgrading the log shipping plans by following the outlined steps below:
1. Disable the Backup, Copy and Restore jobs.
2. If the Backup job was running when the jobs were disabled, make sure the backup process completed.
3. Force the copy job to run on the publisher, make sure it completes.
4. Force restore job to run on the subscriber, make sure it completes.
5. Remove the 4.8 Log Shipping plan. For more detailed information please refer to the information in the following link:
https://support.quest.com/Search/SolutionDetail.aspx?id=SOL20266
6. Verify the publisher and subscriber databases are in sync by comparing the LSN numbers in the MSDB tables. Script for Publisher and Subscriber are attached.
7. Setup the 6.0 Log Shipping plan using the LiteSpeed Log Shipping GUI wizard. Note: Since the servers are in sync, when specifying backup options you do not need to check the box for perform full backup.
Regarding the Sql Server Upgrade, make sure to disable all the LiteSpeed jobs prior to the SQL Server upgrade. Once the upgrade is complete, rerun the LiteSpeed Instance Configuration and enable all the LiteSpeed jobs. You should be able to restart the Log Shipping Plan once the upgrade is complete. We do recommend that you upgrade the subscriber first to 2008 just in case, since you can restore from 2005 to 2008 but not from 2008 to 2005.
