SQL Server Performance

ReInstallation

Discussion in 'General DBA Questions' started by srinivas143, Feb 16, 2006.

  1. srinivas143 New Member

    Hi All,

    We had installed SQL Server 2000 standard edition with SP4 on our production Box.
    How can I reinstall SQL Server 2000 Enterprise Edition with SP3a without losing existing databases.

    Thanks,
    Srinivas
  2. benwilson New Member

    I am pretty sure microsoft provides instructions for removing service packs- check out their site or Google for instructions! Not sure if you would have to reinstall SP3a afterwards, or if it will rollback to 3a...

    'I reject your reality and substitute my own' - Adam Savage
  3. ghemant Moderator

    Hi,
    refer below link for removal of SQL Server Service Pack :
    http://support.microsoft.com/default.aspx?scid=kb;en-us;314823&sd=tech

    take your USER DATABASE(s) Full Backup and then install Enterprise Edition , refer below link :

    http://download.microsoft.com/downl...-4f73-bbcd-9d7451fddbbc/stepup_license_v4.doc

    support.microsoft.com/kb/281574

    http://www.sql-server-performance.com/jk_sql_server_upgrade2.asp


    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

Share This Page