[dba-SQLServer] Restoring Database from Another server

David Emerson newsgrps at dalyn.co.nz
Thu Dec 14 12:32:21 CST 2006

The users we want are the existing ones on the destination server, 
not the source server.  They already exist for another database on 
the destination server.  Will I need to save the current users on the 
destination server and reapply them once the database is restored?


At 15/12/2006, you wrote:
>There are, if you re-created users on each server then the mappings
>for rights won't go over well, You can always run the ophaned user
>script to re-enable this easily or, alternatively migrate user
>information from the source server to the destination, if this was
>done initially then there won't be any problems.  I'm curious tho, you
>say your db may be corrupt, I've seen very few "suspect" dbs on Sql
>Server 2000 what are the symptoms you are experianceing?
>On 12/14/06, David Emerson <newsgrps at dalyn.co.nz> wrote:
> > I sent this to the general list but it seems more appropriate for this one.
> >
> > I am looking at the probability of needing to restore a database from
> > my development computer to a client site (overwriting the old
> > possibly corrupt version).
> >
> > There are users and permisions set up on both computers (they should
> > be identical)
> >
> > Are there any things I should be aware of that may cause problems (eg
> > user and role settings not being compatible across the two computers?)
> >
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> >
>http://sqlthis.blogspot.com | Tsql and More...
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list