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

    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...
  2. ashish287 New Member

  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.
  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.

Share This Page