Post reply

upgrade sql 2000 standard to enterprise?

  • December 18, 2006 at 3:04 am

    #75104

    Hi,

    Anyone know how to upgrade sql 2000 standard edition to Enterprise edition? i am trying to do this because just found the server i'm going to setup log shipping is standard, but only enterprise edition support this function.

    I have enterpirse edtion license, want to know how to upgrade without affecting current production DB.

    P.S is sql 2000 standard support replication?

    thanks,

    Jack

  • December 18, 2006 at 6:25 am

    #678617

    Replication is supported in the standard edition. Log shipping can also been done by manual implementation.

    The only reason so far I would like to upgrade to enterprise is it can use more memory (>2gb) and 2005 requires some additional testing (syntax, system tables ...)

  • December 18, 2006 at 7:31 am

    #678644

    I believe you just "install" SQL 2000 and get the option to upgrade the existing version. I know if your OS support Enterprise, the products allow upgrades and installation of additional components.

    http://www.google.com/url?sa=t&ct=res&cd=10&url=http%3A%2F%2Fmsdn2.microsoft.com%2Fen-gb%2Flibrary%2Faa176562(sql.80).aspx&ei=NqWGRenmGpbMgwPtosTWCA&usg=__XDYH_sb31uuI3FDTKs8n2Zd5yWw=&sig2=34axKrs--PtkiNllc5cmcQ

  • December 18, 2006 at 8:33 am

    #678685

    Thanks Steve's comment, this is exact what i needed, i went through the instruction, it is very straightforward, the only concern i have is it needs a reboot.

    Alternatively, i am very interested in the manual setup log shipping Jo Pattyn mentioned, where can i find instructions?

    Thanks all for the help.

    Jack

  • December 18, 2006 at 10:26 am

    #678733

    Have a look at

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

    to setup logshipping.

  • December 18, 2006 at 11:09 pm

    #678855

    Thanks again everyone!

Viewing 6 posts - 1 through 5 (of 5 total)

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