Best way to upgrade for SQLServer2000 standard to Enterprice

Hi all.
One of our customers need SQL to run on more than 2GB of memory. They are
running on SQL2000 standard edition and therefor need to upgrade to
Enterprice edition. Is it just to install then new CD's over the old system
or do we need to do it as a reinstall of the server and some backup/restore
of the database? Our customers talked about some wizards to do this. Any
"best practice" advice anyone?
Thanx
GeirGeir ,
it's really simple. Just run the setup select the option upgrade and if
necessary add some (new) components. It shouldn't take more tha 2
minutes and if I there's no need to reapply service packs.
But as always, make sure you have a backup of all your databases
including the system databases before you start.
Markus|||Hi
The amount of memory you can use also depends on the version of the OS you
are using, which you haven't specified.
If you haven't already check out:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
You should be able to install over your existing system, make sure that you
have backups of all your databases and a recovery plan for each stage in the
process, so that you know exactly how to get your system back up and running
in the event of problems being encountered.
John
"Geir Holme" wrote:

> Hi all.
> One of our customers need SQL to run on more than 2GB of memory. They are
> running on SQL2000 standard edition and therefor need to upgrade to
> Enterprice edition. Is it just to install then new CD's over the old syste
m
> or do we need to do it as a reinstall of the server and some backup/restor
e
> of the database? Our customers talked about some wizards to do this. Any
> "best practice" advice anyone?
> Thanx
> Geir
>
>|||Geir ,
it's really simple. Just run the setup select the option upgrade and if
necessary add some (new) components. It shouldn't take more tha 2
minutes and if I there's no need to reapply service packs.
But as always, make sure you have a backup of all your databases
including the system databases before you start.
Markus|||Hi
The amount of memory you can use also depends on the version of the OS you
are using, which you haven't specified.
If you haven't already check out:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
You should be able to install over your existing system, make sure that you
have backups of all your databases and a recovery plan for each stage in the
process, so that you know exactly how to get your system back up and running
in the event of problems being encountered.
John
"Geir Holme" wrote:

> Hi all.
> One of our customers need SQL to run on more than 2GB of memory. They are
> running on SQL2000 standard edition and therefor need to upgrade to
> Enterprice edition. Is it just to install then new CD's over the old syste
m
> or do we need to do it as a reinstall of the server and some backup/restor
e
> of the database? Our customers talked about some wizards to do this. Any
> "best practice" advice anyone?
> Thanx
> Geir
>
>