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
Solved

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

Posted on 2008-06-26
3
282 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
3 Comments
 
LVL 10

Accepted Solution

by:
TOPIO earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 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