Re: Database Users disappered after restore

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/29/03 

Date: Thu, 28 Aug 2003 18:02:03 -0400

Most likely will be cleared up with sp_change_users_login but have a look
here:

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 

-- 
Andrew J. Kelly
SQL Server MVP
"Oladimeji Suberu" <ladi.suberu@systemtech-ng.com> wrote in message
news:0bdc01c36d6b$4b8bd790$a501280a@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 attach method of transact SQL.
> At the end of any of the operation, the databasers are
> removed from the database living dbo only.
>
> Has anybody experienced this?
>
> Please help.
>
> Oladimeji Suberu
>

Relevant Pages