SQL Server Performance

How to upgrade personal edition to standard edition

Discussion in 'General DBA Questions' started by cplimmy, Aug 20, 2010.

  1. cplimmy New Member

    Hi,
    I would like to know how to upgrade existing sql server 2000 personal edition to sql server 2000 standard edition.
    what is the procedure/steps need to be done?
    how to migrate databases, system users, user priviledge...
    thanks
    regards
    cplimmy, Aug 20, 2010
    #2

  2. ashish287 New Member

    ashish287, Aug 20, 2010
    #3

  3. satya Moderator

    Edition upgrade is no different to usual move of databases, in this case follow what Ashish referred and make sure you have complete backups for databases, logins and any other information that is essential fro your application.
    satya, Aug 20, 2010
    #4

  4. Luis Martin Moderator

    You can upgrade (Ashish referred) or you can backup databases, users, jobs and permissions (there is a lot of scripts to help you) install a fresh copy of Sql 2000 standard and restore.
    In any case don't forget to full update statistics after all was done.
    Luis Martin, Aug 23, 2010
    #5

Share This Page