Upgrading from MSSQL 2000 Personal Ed to Standard Ed

Last Post 03 Dec 2004 04:15 AM by marcelok. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

26 Nov 2004 03:57 AM
Hello everyone

I have to upgrade from Personal SP3 to Standad Edition. The How-to in MSDN


explain this task.

However here the step 7 the option "Upgrade" appears in disable mode.

So, I'm thinking in execute the following steps:

- Backup all databases, user's and system's
- Copy os all datafiles, for security (!)
- Uninstall Personal
- Install Standard
- Install SP3
- Restore master and msdb

I hope the system be restored. Is it OK?

Anyway I will have all backups.


New Member
New Member

03 Dec 2004 04:15 AM
Hello again,

As a said before, when you perform the actions as MSDN says, the steps 6 and 7 doesn't work as written there.

But the command select @@version now show the Standart Ed.

So, the server is updated.

See you

Acceptable Use Policy