Need Assist. in upgrade of sp4 from sp3 on sql server 2000

[mmuzaffar]

Hi i am trying to upgrade the service pack sp3 to sp4 on my sql server 2000 database and i have downloaded the sp4 files from microsoft which are as follows

SQL2000-KB884525-SP4-x86-ENU.EXE
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
SQL2000.AS-KB884525-SP4-x86-ENU.EXE

i stoped the SQL services and executed the above files with a thought that it will upgrade to SP4,
after turnning on the services of SQL server i tried to check if the service pack is upgraded by running the follwoing queries

SELECT SERVERPROPERTY('productversion')

SELECT SERVERPROPERTY('productlevel')

it still showing the old version which is
8.00.760 , SP3

i am wondering did i miss any part or do i have to run the above files in some specific sequence,
any kind suggestions will be highly appreciated
thanks

 

[Jamfool]

The files u downloaded are self extracting archives. you need to go to where they extracted themselves and run the appropriate one to perform the upgrade.e.g the msde one for and msde upgrade. (BACK EVERYTHING UP BEFORE YOU START)

 

[mmuzaffar]

Thanks for you prompt reply, i am wondering is there any known problems associated with the sp4 upgrade because so far all the databases on sql server with sp3 are running fine as it is going out of support so i have to upgrade it to current version
but you know some issues/problem associated with sp4 then please do let me know
thanks

 

[Jamfool]

I have upgraded dozens without a problem, but its always best to take full backups just in case.