Database Users disappered after database restore

From: Oladimeji Suberu (ladi.suberu_at_systemtech-ng.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 07:15:03 -0700

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: Losing default settings it table fields after database restore
    ... When you originally did your export using DTS did the defaults come across? ... A BACKUP/RESTORE will take everything across so I do not think it is here that things are getting lost. ... using DTS to import from SQL Server to SQL Server (and then Backup ... to make a .bak file of the imported database). ...
    (microsoft.public.sqlserver.dts)
  • Re: moving a db
    ... You can copy the data over to SQL Server 7 using DTS or BCP. ... You can't move the entire database with backup/restore or ...
    (microsoft.public.sqlserver.server)
  • Database Users disappered after restore
    ... I am trying to restore a database from one machine to ... I 've tried using Backup/Restore and equally ... using DTS. ... I equally used attach method of transact SQL. ...
    (microsoft.public.sqlserver.security)
  • Re: Copy SQL Server Objects Fails for certain views
    ... Backup/Restore as transparent to the customer as our DTS package currently ... Our customers don't typically know a database from a monkey wrench. ... Copy objects just uses an alphabetical order. ...
    (microsoft.public.sqlserver.dts)
  • Re: Importing From an Access DB Secured with a Workgroup Information File
    ... > In the DTS designer there is an Access icon to use. ... > How can I dynamically set the Access System Database ... > source as Microsoft Access,choose the file path of the .mdb file, provide ... >> secured with a unique Workgroup file (as described in the Access ...
    (microsoft.public.sqlserver.dts)