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? David 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? > >ref: >http://sqlthis.blogspot.com/2006/01/migrating-logins-from-one-sql-server.html > > >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 > > > > > >-- >-Francisco >http://sqlthis.blogspot.com | Tsql and More... >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com