6.5 upgrade - pls help!

I am having problems upgrading from 6.5 to 2000 using the
upgrade wizard. We have a 6.5 server called medisec that
we want to upgrade to a 2000 server called medisec2000. I
wanted to test the upgrade so I made a copy of the 6.5
database from medisec server to another 6.5 server that I
called medisec2. I then ran the upgrade wizard from
medisec2 to medisec2000 which ran ok. I then wanted to
upgrade the 'live' medisec server so I deleted the
upgraded database and tried to run the upgrade wizard
again. I got an error "You have already started upgrading
from MEDISEC2. You can not consolidate MEDISEC into
MEDISEC2000. The export server name has been changed to
the server you already started to upgrade." It looks like
it doesn't like me trying to upgrade from a different sql
6.5 server as it thinks I am trying to consolidate from
multiple 6.5 servers. I am not doing this though and just
want to somehow 'reset' the test upgrade. I don't really
want to try reinstalling sql 2000 on medisec2000 as this
server is already running other live apps. Can I
somehow 'reset' the medisec2000 server so that I can run a
fresh upgrade from the other server'Nick,
Why not install another instance of SS2000 and upgrade to that instance.
Then detach the databases from your new instance and attach them to
MEDISEC2000.
After that, you can remove the temporary instance you used for your upgrade.
Russell Fields
"Nick Astles" <nick.astles@.coch.nhs.uk> wrote in message
news:116201c35b2e$65dd96f0$3501280a@.phx.gbl...
> I am having problems upgrading from 6.5 to 2000 using the
> upgrade wizard. We have a 6.5 server called medisec that
> we want to upgrade to a 2000 server called medisec2000. I
> wanted to test the upgrade so I made a copy of the 6.5
> database from medisec server to another 6.5 server that I
> called medisec2. I then ran the upgrade wizard from
> medisec2 to medisec2000 which ran ok. I then wanted to
> upgrade the 'live' medisec server so I deleted the
> upgraded database and tried to run the upgrade wizard
> again. I got an error "You have already started upgrading
> from MEDISEC2. You can not consolidate MEDISEC into
> MEDISEC2000. The export server name has been changed to
> the server you already started to upgrade." It looks like
> it doesn't like me trying to upgrade from a different sql
> 6.5 server as it thinks I am trying to consolidate from
> multiple 6.5 servers. I am not doing this though and just
> want to somehow 'reset' the test upgrade. I don't really
> want to try reinstalling sql 2000 on medisec2000 as this
> server is already running other live apps. Can I
> somehow 'reset' the medisec2000 server so that I can run a
> fresh upgrade from the other server'