| Andrea Montanari 2006-01-20, 7:23 am |
| hi June,
June Macleod wrote:
> I have a database in MSDE2000 sitting on one machine and I want to
> transfer it to another machine which has SQL Server 2000.
>
> Can I simply backup the database and restore it on the second
> machine? Or do I need to create the database/Users etc on the second
> machine first?
>
> What would the best way of performing this task be? Any help would
> be much appreciated.
>
you can both perform backup/restore and sp_detach_db/sp_attach_db..
the original database users, that are part of the database involved itself,
will be "transferred" to the destination server, but the corresponding
logins will not...
so you have to take care of the well known "orphaned users" problem..
you have that way to create SQL Server logins on the destination server and
manage the re-mapping as logins<->users are mapped via the sid column of the
master..syslogins.sid = database..sysusers.sid JOIN...
http://www.sqlservercentral.com/col...rokenlogins.asp
explain these concepts in detail, and you have to resort on
sp_change_users_logi
n system stored procedure to take care of the problem...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
|