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

Upgrading SQL Server 2000 RTM to Service Pack 4

Just started working with a server which has multiple roles, e.g., DC, SQL Server 2000 RTM and Exchange 2003.  The SQL server 2000 application has been freezing up recently and discovered Microsoft will not even support unless it is upgraded to Service Pack 4.   As it is currently still on the initial RTM service pack, I am wondering what is the process to follow moving to SP4 and what precautions should be taken (other than backing up the DB)?

Thank you!  
0
Rainman13
Asked:
Rainman13
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
nothing else than a backup of the databases is needed...
apart from eventually testing the procedure on a test server.
0
 
TAB8Commented:
Make sure you back all ALL databases including the system databases as there is no rollback ...  it a reinstall of SQL .. So make sure you also have the install cd an key etc if anything was to go wrong ..
0
 
Rainman13Author Commented:
Great - thanks.  Do I need to go to SP1 first and then to SP4?  Or can I go directly to SP4 from RTM?

Rainman13
0
 
Rainman13Author Commented:
Thanks guys - finally found time to do this upgrade and all worked great.  Also used the readme file that comes with the SP4 install that definitely helped to cover all the steps.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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