Re: Upgrade from Personal to Standard?

Hi,

You can directly do a edition upgrade by inserting the Standard edition CD.

http://www.windowsitpro.com/Article/ArticleID/20246/20246.html?Ad=1

Thanks
Hari
SQL Server MVP





"Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11CFE6AD-C380-4B21-90EE-009F2D9DF82D@xxxxxxxxxxxxxxxx
> Sorry if this is a stupid question but I'm afraid I have no experience of
> SQL
> Server at all.
>
> We have a system recently installed here which is running on SQL Server
> 2000
> Personal Edition. We need to upgrade this to 2000 Standard Edition.
>
> Can anyone tell me how I do this and how I keep all our existing data? I
> can
> find plenty on upgrading from 6.5 and 7 but not from Personal. Would
> appreciate any help as I'm sure you can understand I'm kind of nervous
> about
> trying this just in case something horrible happens! :-O
>
> As I say I know nothing at all about SQL Server - currently working my way
> through a big thick book!
>
> Thanks for any advice
>
> Dave
> :o)


.

Relevant Pages

  • Re: Upgrade Path - Do I need to downgrade first?
    ... can I do an in-place upgrade directly to 2k5 SE without first ... I downgraded/upgraded from SQL Server 2000 Enterprise Edition to SQL Server ... those will no longer work in Standard Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Personal Edition
    ... Does the MS SQL Server 2000 Standard Edition that is included on ... the Small Business Server 2000 Premium edition include MS SQL Server Personal ... it would have also included Personal Edition. ... > purchased it bundles with Small Business Server (because I told hime that SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Upgrading SQL 2005 Express to Standard
    ... You cannot upgrade a 32-bit instance of SQL Server to native 64-bit. ... you can upgrade a 32-bit instance of SQL Server to the WOW64: the 32-bit subsystem on a 64-bit server. ... I have Windows 2003 Server x64 machine with SQL Server 2005 Express Edition with Advanced Services with Service Pack 2 installed. ... The Standard Edition I'm trying to install is 64bit and doesn't come with SP2. ...
    (microsoft.public.sqlserver.setup)
  • Re: Proliant HP 380 With SQL Server
    ... You can upgrade Standard Edition to Enterprise without a full reinstall. ... SQL Server MVP ... > processors should i upgrade to Enterprise Edition ?? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 Standard Edition: Evaluation copy is expired
    ... "Katrin Schulz" wrote in message ... > After this message I did an upgrade from the evaluation version to the ... the sql server worked again. ... >>> version to the standard edition. ...
    (microsoft.public.sqlserver.server)