Help me fix an install mistake!

Question

Help me fix an install mistake!

Cory E.

SSCertifiable

Points: 7076
More actions
February 14, 2006 at 6:40 am

#116155

Guru's,
I made a mistake. I recently moved a couple of servers from their old server to the new hardware. When I installed SQL Server, it appears that I have installed standard, when I wanted enterprise. We wanted to utilize the /AWE and other tools that require us to use enterprise. The old hardware had Enterprise installed. Can I easily rectify this problem? I am hoping to not have to rebuild the databases, as they total a little over a terabyte of data.
Please help!
Cory
-- Cory

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

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

Jason Hall Hall of Fame Points: 3906 More actions · Answer 1

You should be able to detach all of your user databases, re-install the enterprise version of SQL Server and then re-attach the databases to the new version.

Cory E. SSCertifiable Points: 7076 More actions · Answer 2

What about Master and MSDB? I need the user information as well as the jobs, the schedule, and such. Can I simply dettach those and re-attach?

-- Cory

Jason Hall Hall of Fame Points: 3906 More actions · Answer 3

Didn't realize you needed those too. You won't be able to use master with a different version of SQL Server (I don't think). I don't know a good automated way to migrate this information without doing it manually.

Cory E. SSCertifiable Points: 7076 More actions · Answer 4

Well - what is in master that I need? does it just sotre DB locations and such? so, really, msdb contains the users and schedules?

So, can someone tell me if this is viable?

I detach the DB's, all user and system (minus the master)

reinstall enterprise

re-attach msdb, then all user DB's - then, I should still have users and jobs and schedules?

Back in buisness?

TIA

Cory

-- Cory

Cory E. SSCertifiable Points: 7076 More actions · Answer 5

I found this in the BOL:

Upgrading From One Edition to Another

These are the supported upgrade paths between the editions and versions of SQL Server 2000:

SQL Server 2000 Personal Edition to either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.
SQL Server 2000 Standard Edition to SQL Server 2000 Enterprise Edition.
SQL Server 2000 Desktop Engine (MSDE 2000) to SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.
SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 Developer Edition, or SQL Server 2000 Personal Edition. SQL Server 2000 Enterprise Evaluation Edition upgrades are not supported in failover clusters.

Does anyone have any documentation or experience with this?

-- Cory

Cory E. SSCertifiable Points: 7076 More actions · Answer 6

I found the following link - which may help someone in the future...

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

Thanks all for your help!

-- Cory