Re: Enterprise to Standard

Master, model, msdb, tempdb are also installed. User databases 'should' not
be removed on un-install, so they will be in the same location after
installation. But you 'should' have to attach them.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

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


"dusty" <dusty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11F61529-7133-4245-973C-266C4B86900D@xxxxxxxxxxxxxxxx
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: Access 2: Cant Perform Join- Combined Fields Too Long
    ... I am still maintaining Access 2.0 databases, ... installation procedure on each PC'. ... machines, figuring I suppose that anyone who wanted to use Access ... point to the former Office installation which was on Drive C (which on ...
    (comp.databases.ms-access)
  • Restore databases into a new installation of SQL Server
    ... I want to restore my databases from the old SQL Server installation ... Can anyone tell me how to restore my databases from the old SQL Server ...
    (microsoft.public.sqlserver.server)
  • MS Visual Basic Help window doesnt display help on some topics
    ... The first five topics listed are "CreateDatabase Method", "Databases ... When I type "recordset" in the lookup box, of the twenty topics to display ... copy of Office on the computer--just a bare-bones installation. ... a tip from a friend, and custom installed just about everything except clip ...
    (microsoft.public.access.setupconfig)
  • Re: FreeBSD MySQL still WAY slower than Linux
    ... > yes random IO is more targetted to Databases. ... > noop, i have the installation always made in the same way, and i have respected ... certainly not the issue effecting database performance - for instance I ... find Postgresql consistently faster on RELENG_5 than on ...
    (freebsd-stable)
  • Re: MSDE and VS.NET Quickstart Tutorials
    ... databases (master, model, msdb, and tempdb). ... the 80\Tools\Binn directory of your installation. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)