Re: Unable to upgrade SQL 2000 Evaluation to SQL 2000 retail version

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Lazaros Lazarou (l.lazarou_at_cytanet.com.cy)
Date: 07/13/04


Date: Tue, 13 Jul 2004 13:22:01 +0300

Thanks for the suggestions, they are very helpful.

Regards
Lazaros Lazarou

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:OidTowLaEHA.3524@TK2MSFTNGP12.phx.gbl...
> I think you can just back up the msdb database (all the jobs are stored in
> there) and restore that on your new installation. Although it is probably
> safer to script out everything and run the script on your upgraded server.
>
> The following KB article will be helpful:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Lazaros Lazarou" <l.lazarou@cytanet.com.cy> wrote in message
> news:uajheZLaEHA.2488@tk2msftngp13.phx.gbl...
> > Reinstall would be my next move. I was trying to avoid reentering all
the
> > Jobs (Backup, replication, delete replication logs, etc).
> >
> > Regards
> > Lazaros Lazarou
> >
> > "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid>
> wrote
> > in message news:%232ramkBaEHA.712@TK2MSFTNGP11.phx.gbl...
> > > I can't see why the upgrade wouldn't work, but if you don't get any
> > answers
> > > that solve your problem, you can detach your databases (assuming you
> want
> > to
> > > keep them) from the Evaluation Edition server, uninstall Evaluation
> > Edition,
> > > install Standard Edition and re-attach your databases.
> > >
> > > --
> > > Jacco Schalkwijk
> > > SQL Server MVP
> > >
> > >
> > > "Lazaros Lazarou" <l.lazarou@cytanet.com.cy> wrote in message
> > > news:OAaX8UBaEHA.2388@TK2MSFTNGP11.phx.gbl...
> > > > The OS is Win2K server with SP4. I am trying to upgrade to SQL
Server
> > 2000
> > > =
> > > >
> > > > Standard from SQL Server 2000 Evaluation edition.
> > > >
> > > > Thank you in Advance
> > > >
> > > > Lazaros Lazarou
> > > >
> > > > "Jacco Schalkwijk"
<jacco.please.reply@to.newsgroups.mvps.org.invalid>
> > > wrote
> > > > in message news:e9UdPvAaEHA.4048@TK2MSFTNGP10.phx.gbl...
> > > > > Which operating system are you running on? SQL Server Standard and
> > > > > Enterprise Edition can't be installed on Workstation OS'es
(Windows
> XP
> > > > > Pro/Home, Win 2000 Pro) but Evaluation Edition can.
> > > > >
> > > > > --
> > > > > Jacco Schalkwijk
> > > > > SQL Server MVP
> > > > >
> > > > >
> > > > > "Lazaros Lazarou" <l.lazarou@cytanet.com.cy> wrote in message
> > > > > news:%23Pg19S$ZEHA.1152@TK2MSFTNGP09.phx.gbl...
> > > > > > Hi everybody,
> > > > > >
> > > > > > I need some help with an upgrade. I Purchased the
SQL
> > > > server
> > > > > > 2000 retail evaluation and tried to upgrade the SQL server
> > Evaluation
> > > > > > edition with no luck. I run the option "Upgrade, remove, or add
> > > > > components
> > > > > > to an existing instance of SQL Server", but the "Upgrade your
> > existing
> > > > > > installation" option is disable. Does anybody knows how to
solve
> > this
> > > > > > problem
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thank you in Advance
> > > > > >
> > > > > > Lazaros Lazarou
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>