Re: Enterprise to Standard

When uninstalling sql 2000 ee and installing sql 2000 se are the default
databases (master, model, etc) new databases from the sql 2000 se
installation? Reason I'm asking is because I installed directly to the same
directory using same instance name and all databases remained there even
after uninstalling sql 2000 ee.

Thanks

"Arnie Rowland" wrote:

I would detach and then re-attach. Take care to script out everything that
may be located in master and msdb. Those references will walk you through
the process.

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"dusty" <dusty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4F25E51-54C7-42E0-8C28-2D25288E7CAE@xxxxxxxxxxxxxxxx
Thanks for the reply. So even though I'm not actually moving the database
from one server to another, I should still use the detach & attach
function?
All I'm doing is uninstalling EE and installing SE on my current sql
server.

Thanks

"Arnie Rowland" wrote:

This is for a 'heads-up' awareness. For a more detailed outline see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
http://vyaskn.tripod.com/moving_sql_server.htm

Detach the databases, then after some of the following prep work,
re-attach
them.
You will need to transfer logins, etc.
SQL Agent Jobs are located in MSDB and should be scripted out.
Any objects intentionally (or unintentionally) created in master need to
be
scripted out.

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"dusty" <dusty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:245417BD-8014-4FFD-AB47-584A632B0CE4@xxxxxxxxxxxxxxxx
Because of License issues, I will be uninstalling SQL Server 2000 EE,
and
installing SQL Svr 2000 SE (Win 2k Adv Svr). There are two instances
running
on my current configuration. I will include only one of the two
instances
on
the new install to SE.
I have read about detaching & attaching when moving the database from
one
server to another, but I really haven't found any hard information
about
my
upcoming task.
My plans were to backup the databases, uninstall EE, install SE (with
same
instance name that was running on EE), and restore databases.
As far as my database backup, I will simply copy the database folder to
another location, as well as my backup folder. When restoring the
databases,
should I use the mdf or .BAK files?
Will all of my login accounts transfer or will I have to re-create them
again? Is there anything that I left out or should consider before I
begin
this task?

TIA







.

Relevant Pages

  • Re: SQL 2000 - Installing and uninstalling KB960083 patch
    ... This isn't SP4 that we are installing. ... This is patch after SP4 which brings the SQL version to 8.00.2282. ... To revert to a pre-SP4 version of SQL Server ... Detach all user databases. ...
    (microsoft.public.sqlserver.server)
  • Northwind problem after an MSDE installation on NT4.0
    ... I am installing an instance of MSDE on an NT4.0 workstation, ... The settings file containing the following: ... I try to enumerate the databases on the server using SQL DMO ...
    (microsoft.public.sqlserver.setup)
  • Re: Unable to reinstall SBS Monitoring
    ... Uninstall Windows SBS 2003 R2 components". ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to reinstall SBS Monitoring
    ... but it's possible the MSDE instance for the monitoring database did not remove the registration from the registry and when you reinstall it it finds the key and it can't proceed. ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)