Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to install Service Pack on SQL Server 2000 Replication server Expand / Collapse
Author
Message
Posted Wednesday, January 19, 2011 5:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 3:17 AM
Points: 291, Visits: 488
Hi Experts,

We have a SQL Server 2000 Standard Edition Installed with Replication having Service pack 2 on main server(Publication & distributor) & Service pack 1 on replicated server, below is the output of @@Version commans

Server 1
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Server 2
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Our requirement is to install latest service packs on both these severs, since I am new to this so I have a question
1) Which service pack do we need to install on both servers?
2) How to Install service pack? I mean any guidelines!
3) If any error comes while installing, How to rollback the installation?

any help on this is realy great for me!


Thanks,
Post #1049970
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse