?
Solved

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

Posted on 2008-06-26
3
Medium Priority
?
288 Views
Last Modified: 2008-09-14
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
Comment
Question by:mitsdev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
TOPIO earned 2000 total points
ID: 21878756
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question