Re: Database Users disappered after restore

From: Mike Epprecht (mike_at_epprecht.net)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 16:56:32 +0200

Hi

Your users are stored in master. More importantly, the user ID and name is
the only reference in you database. sp_attach_db and sp_detach_db do not
move the master information, and since the same user does not exist on the
other machine, the linkage is lost.

On the other server, if you try to add a user to the database with the same
name, you will notice that it claims that the user already exists in the
database. That is because your user ID does not match the user name.

It is recommended to remove all users from a database before an
attach/detach so that you do not have orphaned users.

----------------------------
Mike Epprecht
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268

Specialist SQL Server Solutions and Consulting

"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

  • Re: Replication problems
    ... An error occurred while accessing the DHCP database. ... DHCP server event log for more information on this error. ... browser for the domain on transport NetBT_Tcpip_{99B638B5-2C0B. ... master browser is stopping or an election is being forced. ...
    (microsoft.public.windows.server.active_directory)
  • RE: SQL Server failing to start (directly effecting sales!!!) Error: 823, Severity:
    ... You should consider calling Microsoft Technical Support as your master ... They will want your SQL Server Errorlogs ... that the machine with the database has hardware that is failing. ... Even if you are planning to reinstall you should make a backup copy ...
    (microsoft.public.sqlserver.msde)
  • Re: Table Normalization
    ... To master it requires a great deal more work. ... There are so many categories to work in (database design, queries, forms, ... that they'd flub a number of the answers, ... make the same mistake twice, and they don't let others make the same ...
    (microsoft.public.access.tablesdbdesign)
  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)
  • RE: Multi user database
    ... manner and push updates to the backend. ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
    (microsoft.public.access.modulesdaovba)