Re: Upgrade from Personal to Standard?



Many thanks. That seems straightforward enough then. I'll give it a go. Think
I'll read the section on backing up first though! ;o)

Thanks

Dave


"Hari Prasad" wrote:

> 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: Can I install SQL Server Enterprise on Windows 2000 SBS
    ... I don't think you can create indexes on views via Enterprise Manager, ... topic "Creating an indexed view" in SQL Server Books Online. ... > I create a view in SQL Server (Standard edition in my SBS) ... >>> Enterprise edition says requires Windows 2000 Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Microsoft Forefront Client Security on SBS 2003 R2
    ... purchase the SQL 2005 standard edition as well as the CALs just as Cris ... we can install SQL Server 2005 Standard Edition on Windows Small ... SQL Newsgroup: microsoft.public.sqlserver.server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • 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: Versions and reccomendations
    ... > Then you could interact with up to three outside companies using BTS 2004: ... > PeopleSoft Systtem, SAP System, and Sql Server. ... > would have to upgrade to the Standard Edition to be legal. ... > license, ...
    (microsoft.public.biztalk.general)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (microsoft.public.sqlserver.setup)