Re: Database Users disappered after database restore

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 10:25:30 -0400

Check out sp_change_users_login in the BOL. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Oladimeji Suberu" <ladi.suberu@systemtech-ng.com> wrote in message news:063501c36d6e$c61d6070$a001280a@phx.gbl...
I am trying to restore a database from one machine to 
another.  I 've tried using Backup/Restore and equally 
using DTS.  I equally used db attach method of transact 
SQL.  
At the end of any of the operations, the database users 
are removed from the database leaving dbo only.
Has anybody experienced this?
Please help.
Oladimeji Suberu

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: HELP!!! restore database - left in loading state?? PLEASE H
    ... Columnist, SQL Server Professional ... can just say RESTORE DATABASE TESTDB WITH RECOVERY, ... > You have to restore the database somewhere. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: Restore Master DB to New Server
    ... the user database will be suspect. ... Just drop them and then do the restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)