Re: How to apply SP4 to SQL Server 2000 Log Shipping

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, Mike. I am attempting to accomplish the same task. How did this work
out for you? Thanks.

Chris

"Mike" wrote:

Thanks Hilary. I can't afford to fail the system over unless absolutely
essential, so I'll try the standby first. Thanks for the help.

"Hilary Cotter" wrote:

The recommendation is to apply the sp/hot fix to the standby, then to the
primary. There are two ways of doing it, apply to the primary, then
failover, apply to the secondary. The other way is to apply to the
secondary, then apply to the primary without failing over. You should apply
to the monitor server at the same time.

I don't have specific knowledge if you can ship to one server running sp3
and another running sp4, but it should be ok.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8A519AE1-4C6F-4D22-AB19-C08952BC4387@xxxxxxxxxxxxxxxx
Can anyone tell me if I can apply SP4 to a standby server while the
primary
server stays on SP3?

Unfortunately, the standby database is in the same instance as the Test
system. I'd like to run the Service pack on the Test system before
applying
it to the production database (the log shipping primary server).

Note that applying SP4 for us also requires a Collation change.

If not, would it work to move the standby database to a separate named
instance on the Test server - could I then patch / upgrade it
independantly
of the Test database?

Any advice appreciated.




.

Relevant Pages

  • Activate Standby Database
    ... I'm upgrading my database server hardware this weekend. ... logs are being copied over and applied right away on the standby. ... Since all redo logs and control files are available, ...
    (comp.databases.oracle.server)
  • Re: How to apply SP4 to SQL Server 2000 Log Shipping
    ... I don't have specific knowledge if you can ship to one server running sp3 ... the standby database is in the same instance as the Test ... Note that applying SP4 for us also requires a Collation change. ...
    (microsoft.public.sqlserver.replication)
  • Re: Using EM 10gR2 to Create Standby Database
    ... database on the same server as the primary database. ... I want the standby created in /t15, not in /u01, but I have not found ... would want a standby on the same server as the primary. ... That server holds only test versions of production databases. ...
    (comp.databases.oracle.server)
  • Re: Using EM 10gR2 to Create Standby Database
    ... database on the same server as the primary database. ... I want the standby created in /t15, not in /u01, but I have not found ... would want a standby on the same server as the primary. ... That server holds only test versions of production databases. ...
    (comp.databases.oracle.server)
  • Re: Ive got 3 WSS sites but no STS_Config files - how does that w
    ... You're correct - I found that I had a wssdb database afterall. ... "Mike Walsh" wrote: ... >> server computer, and for servers in a server farm. ... >> the configuration database. ...
    (microsoft.public.sharepoint.windowsservices)