We have a site that wants to install sql server standard
edition on the top of MSDE. They do not want to Turn off
the MSDE server during the SQL Server install. Does any
one knwo if that is safe, and if it is will it keep all of
the database attachments that MSDE had?


thanks in Advance

Let me make sure I understand what your after. I assume you want to replace
the MSDE with Standard edition of sql server and keep the existing db's. If
that is true and this were my server I would do the following.

1. Make backups of all DB's, DTS packages, Jobs, Logins etc.
2. Detach the dbs
3. Uninstall MSDE
4. Install Standard Edition.
5. Recreate the logins
6. Reattach the db's.
7. Fix any potentially broken links between users and Logins with
sp_change_users_login
8. Add back any Jobs, DTS etc.

While there may be some shortcuts you can take, this way I know exactly what
is happening and have full control etc. Here are some links that may help
with the reattaching.

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

--

Andrew J. Kelly
SQL Server MVP


"Lynn Owens" <lowens (AT) ssinews (DOT) com> wrote