Post reply

SQL Server 2000 Standard to Enterprise Edition

  • March 23, 2004 at 1:18 pm

    #162223

    We are upgrading from SQL Server 2000 Standard to Enterprise Edition.

    Questions.

    (1)  We are considering installing SQL Server 2000 Enterprise Edition on a server running Standard.  Could someone please tell me what is modicifed, e.g., system tables, etc.?

    (2)  If we install SQL Server 2000 Enterprise Edition on a new server, can we restore the system tables from the Standard version on the Enterprise Edition?

    Thank you.

  • March 26, 2004 at 8:29 am

    #500669

    You don't want to restore system tables from a standard install to an enterprise install.   For example MSDB standard edition doesn't contain log shipping tables found in Enterprise edition.  Once you upgrade take new backups.  You should be backing up system tables (especially master and msdb) periodically anyway. 

    Francis

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply