Re: Enterprise to Standard

This information is helpful. Thanks again for you help.

"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: Can you have two SQL instances with the same on the same cluster?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... and am ready to start installation of SQL 2000 and SQL ... I'm installing both SQL2000 and 2005 on the same cluster to make our ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory Recommendations for 8-way Server
    ... How many databases, how large are the databases, how many users on each ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... Mike ...
    (microsoft.public.sqlserver.setup)
  • Re: Hide databases in EM/QA
    ... While I agree that the databases won't show up in the Object Explorer, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.security)
  • Problems/dislikes with Pro 2007 after upgrading from Pro 2000
    ... Just installed the upgrade from Professional 2000 to Professional 2007. ... On installing 2007 upgrade, I selected the ... When opening alllll of them up pops error messages at the switchboard not allowing me into any of the databases: ... Nowwwww this doesn't just happen with my databases but also an Access 2000 sample databases that Microsoft has online for downloading that presumable should work with 2007 Access for included in the list of databases/etc... ...
    (microsoft.public.office.misc)
  • RE: Sharepoint and SBS2003 SP1
    ... I hope you are installing these service packs according to this ... for some reason SBS was looking for the databases on the D drive. ... creating the same folder structure on the D drive and copying the databases ...
    (microsoft.public.windows.server.sbs)