• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

How does the SQL Server 2000 upgrade from SP1 to SP4 affect the log shipping process?

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?
0
mitsdev
Asked:
mitsdev
1 Solution
 
TOPIOCommented:
The exact procedure is here:
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm#_1462462_considerations_for_an_instance_i_gq59

Log Shipping and Database Components
Because non-writable databases do not cause Setup to fail, you need not remove log shipping before upgrading to Database Components SP4. However, if the database is shipping logs to a database that is a replication publisher, you must do the following:

Take the database offline before you apply SP4.


Apply SP4 to the instance.


Bring the database back online.


Log on to Query Analyzer and run the following script:
USE master
GO
EXEC sp_vpupgrade_replication
GO
If you apply SP4 without having taken offline all non-writable databases that ship logs to publication databases, you receive this error:

Error Running Script sp_vpupgrade_replication (1)

If you receive this error, follow the preceding procedure.

Note   During installation, Setup makes no distinction between read-only databases and databases that are offline or in a suspect state. If a replication database or filegroup is offline or in a suspect state during setup and is involved in a replication topology, you must reapply the service pack after making the database writable



0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now