I backup the production database on server named SQL1 then restored the database on server named SQL2. SQL server security login name "user1" has been created on both SQL1 and SQL2 servers. When I restore the database on SQL2 I have to re-map and give db_datareader access to the "user1" user name again. How can I fix the problem of having to re-map and give db_datareader access everytime I restore the database on a second server?
July 20, 2009 8:59 PM
July 21, 2009 6:21 PM