Replication issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication issue

Hi, If we are replicating a database from primary server to another server named test…whether the database that is copied would contain all roles/permissions/users as in primary server. Is it possible to transfer all logins/roles/permissions to test server by any script. If so.let me know. Regards
Suresh.
Replication is more kind of granular process for high availability, it is used to replicate data and not other objects. In order to affect the login privileges you can apply the generated script for logins and their permissions from primary server to secondary server for one time only. And affect the process whenever new login is added or existing login is modified or dropped between the servers. For more availability you can deploy LOG SHIPPING and use secondary server database for rEAD Only purposes.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Can I have the script to transfer users/logins..please Thanks.. REgards
Suresh.
KBA tohttp://support.microsoft.com/default.aspx?scid=kb;en-us;246133 transfer logins and articlehttp://vyaskn.tripod.com/troubleshooting_orphan_users.htm to troubleshoot orphaned users. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Is it possible to transfer the users of a primary server database to secondary server db using script
The same is mentioned on the referred KBA and you can schedule the job regularly to keep the data in sync. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>