Re: Database Users disappered after database restore

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 08:39:05 -0600

in addition to Tom's post refer to following urls:

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.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 

--
-Vishal
"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: Database Users disappered after restore
    ... Issues When a Database Is Moved Between SQL Servers ... "Oladimeji Suberu" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Upgrading Hardware, how best to move?
    ... How To Transfer Logins and Passwords Between SQL Servers ... Q240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers ... Q224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach ...
    (microsoft.public.sqlserver.security)
  • Re: transfer database to new server
    ... Issues When a Database Is Moved Between SQL Servers ... > What is the easiest way to transfer a database over to a new server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Insert Error: Column name or number of supplied values does no
    ... I did use a log file which gets the following: ... As to running interactively, if you don't mean using the database wizard, I ... > table structures are different between your prod and dev SQL Servers. ... > Can you run the DTS package interactively and see on which table you are ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 15022: The specified user name is already aliased.
    ... Issues When a Database Is Moved Between SQL Servers ... > permit role it shows that the user has a dbo role. ...
    (microsoft.public.sqlserver.security)