SQL Server-2000 SP4 Deployment

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server-2000 SP4 Deployment

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-10 : 09:42:45

Sreekanth writes "Hi Experts,

I am gointo upgrade our SQL database servers to Service Pack4. Presently our servers configurations as follows
1) OS : Windows 2000 Server
DB : MS SQL Server 2000 Enterprise Edition with SP3
Db's : 7 Databases.(Contains 950GB Data Each)
Componets : 1)MS SQL Server 2000 Analysis Services
2)MS SQL Server 2000 Reporting Services Ent.Edtn
3)MS Data Access 2.6 SDK lite
4)MS XML parser SDK

2) OS : Windows 2000 Server
DB : MS SQL server 2000 Standar edition with SP3
DB's : 3 Databases.(Contains 350GB Data Each)
Components: 1)MS Data access Components KB870669
2)MS Soap toolkit 3.0
3)MS SQL server Analysis services

Let me know what all steps should i take before & after deploying Service pack4 & Which Services i must stop. All are live servers and having very crucial data.

I downloaded following Files from Microsoft Site.
1)SQL2000-KB884525-SP4-ia64-ENU.EXE
2)SQL2000-KB884525-SP4-x86-ENU.EXE
3)SQL2000.AS-KB884525-SP4-x86-ENU.EXE
4)SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

I am having less experiance in SQL Servers. but i can handle. Can you please advice.

Hope you will do that.

Thanks & reg'ds
Sree"

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2006-08-14 : 11:35:00

If it is a production server Backup is the first thing.
then, restore the backups elsewhere first and test it thoroughly.
Then, upgrade this restored database server to sp4, see if it works.
Then restore again over the same database.
That way you will be sure that your backups are ok, in case all goes awry.

The hot fixes are ok, after that.
Also, ensure that somebody using this production data is actually avaialble for you to test after the upgrade.
The upgrade itself takes only 20 minutes tops including a reboot.

and yes, all the best.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources