How does the SQL Server 2000 upgrade from SP1 to SP4 affect the log shipping process?
Posted on 2008-06-26
We are currently running the Log Shipping Process to keep our Backup server (SQL Server 2000 SP1) in synch with the Primary server (SQL Server 2000 SP1).
I am planning to upgrade the both the Primary and the Backup server from SP1 to SP4 for which I will
stop the LogShipping jobs on the primary and the backup server, install the SP4 update on both the servers and start the jobs back again after the upgrade.
Is there something different that has to be done after the upgrade to make sure that the log shipping process is not affected in any way?