Upgrade from Personal to Standard?

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: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Problem upgrading named instance in SQL 2000
    ... I have installed SQL 2000 Server on my machine with Default Instance ... After selecting the Database Engine ... Reason: Your upgrade is blocked. ...
    (microsoft.public.sqlserver.clients)
  • Re: New Hardware, moving
    ... resources to NodeB and repeat the upgrade. ... Senior Database Administrator ... Microsoft SQL Server MVP ... SQL 2000 and Windows 2003 support up to four node clusters. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSSQL on XP-Pro
    ... These old versions of SQL Server should run on XP. ... There are two ways to upgrade. ... upgrade when you run the 7.0 install. ...
    (microsoft.public.sqlserver.setup)
  • Re: upgrading from SQL 7.0 to SQL2000
    ... I like the idea of doing a fresh install of SQL> 2000. ... > 2) install SQL 7.0 on a separate machine which is a test server. ... > 3) Restore the databases from my production server on to my test server> running SQL 7.0. ... While the upgrade should work just fine I like to start>> fresh if possible. ...
    (microsoft.public.sqlserver.setup)