[dba-SQLServer] Restoring Database from Another server

Francisco Tapia fhtapia at gmail.com
Thu Dec 14 11:51:38 CST 2006


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



More information about the dba-SQLServer mailing list