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

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 10:31:27 +0100

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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: corrupt msdb
    ... > collation than the other system databases. ... > Tibor Karaszi, SQL Server MVP ... > "Jacco Schalkwijk" wrote in message ... rename the msdb data and log files and put ...
    (microsoft.public.sqlserver.server)
  • Re: Database files are "Hidden" after becoming Suspect
    ... Mike Epprecht, Microsoft SQL Server MVP ... > We had created some databases on the C Drive. ... > datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.server)
  • Re: i cannot start sqlservers service
    ... > restore backup of the master ... >> and msdb databases. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: sp_track_db_growth
    ... SQL Server MVP ... > I have added the above listed stored procedure to a number of my servers ... > have been able t use it quite successfully on most databases. ... > Arithmetic overflow error converting numeric to data type numeric. ...
    (microsoft.public.sqlserver.server)
  • Re: sp_track_db_growth
    ... > SQL Server MVP ... >> have been able t use it quite successfully on most databases. ... >> one database that I really want to find out the growth ... >> Arithmetic overflow error converting numeric to data type numeric. ...
    (microsoft.public.sqlserver.server)