Shifting from Standard to Enterprise Edition(SQL Sever2000)

Question

Post reply

Shifting from Standard to Enterprise Edition(SQL Sever2000)

U J

SSCrazy

Points: 2423
More actions
November 17, 2006 at 7:53 am

#61949

dear all,
i m having SQL Server 2000 Standard Edition on my production server.
now i want to deinstall Standard Edition and install Enterprise Edition
but this is production server and i want to retain all databases,Logins,Users,Jobs and maintainance plans as they are in the Standard Edition [?].
Please can anybody tell me wht should i do?
wht will be the Plan Of Action ? [?]
[] Tnks a lot in advance []
-Tushar

Viewing 9 posts - 1 through 8 (of 8 total)

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

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

I think you can upgrade the version from standard to enterprise.

If you do install a clean enterprise version, then,

Backup all your databases;

Uninstall the standard version;

Install the enterprise version;

Start the SQL Server in a single user mode;

Restore all system databases;

Restore all user databases;

Restart the SQL Server

U J SSCrazy Points: 2423 More actions · Answer 2

thks a lot but wht abt the logins ,Jobs,Users,Maint Plans that are created?

they will be removed once i uninstall the standard Edition

so how can i retain them?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

This is why he asks you to backup and restore the system databases first. This is where all that info is saved.

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 4

SQL ORACLE

One Orange Chip

Points: 27807

November 17, 2006 at 8:56 am

#672644

Nice explanations.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Do you know if there is a way to install enterprise over standard and overwrite the previous instance, but keeping all the system databases intact and keeping the user databases?

Balmukund SSCertifiable Points: 6648 More actions · Answer 6

Why don't you go for in-place upgarde? Its supported by Microsoft.

Refer "Upgrading an Existing Installation of SQL Server"

Installed Version	Can upgrade to
SQL Server 7.0 Desktop Edition	SQL Server 2000 Personal Edition SQL Server 2000 Standard Edition
SQL Server 7.0 Standard Edition	SQL Server 2000 Standard Edition SQL Server 2000 Enterprise Edition
SQL Server 7.0 Enterprise Edition	SQL Server 2000 Enterprise Edition
SQL Server 2000 Developer Edition	SQL Server 2000 Enterprise Edition
SQL Server 2000 Standard Edition	SQL Server 2000 Enterprise Edition
SQL Server 2000 Personal Edition	SQL Server 2000 Standard Edition

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 7

Has anyone tried an in-place upgrade fro SQL2000 Standard to SQL2000 Enterprise.

I am looking into it because I want to be able to use more than the 2GB of RAM that Standard limits you to. We have a bunch of 3rd party apps running against DBs on that server that don't yet support 2005 so we can't just upgrade to 2005 yet.

It doesn't seem like it should be that hard, but thought I'd ask.

I wonder what Microsoft will charge for the upgrade...

The Redneck DBA

homebrew01 SSC Guru Points: 55539 More actions · Answer 8

We just did it a couple of weekends ago. "Piece of cake" You just use the Enterprise Installer, and select the upgrade option. I think it was a grand total of 10 "clicks" plus a reboot and I was done. Took longer to read the document than to actually do the upgrade.

See:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

There are a few settings to change to make use of the extra RAM.