SQL Server Performance Forum – Threads Archive
Export and ImportHi I am new to this forum and also SQL-Server. Basically I am a Oracle guy. Recently I started working on SQL-Server Databases. Seeking your help for the following: I have two servers running SQL-Databases, one is production and other is DR. User wants to test DR. I need to sync the sysxlogins table from production to DR Server. How can I do this. Thanks in Advance.
Can take help from the following articles :
http://www.databasejournal.com/features/mssql/article.php/2228611 – migrate logins
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 – to move/copy logins
http://support.microsoft.com/default.aspx?scid=kb;en-us;240872 – resolve permission when databases are moved.
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm – KBA to troubleshoot orphaned users.’ And above all refer to thishttp://www.sql-server-performance.com/disaster_recover_examples.asp link about planning and deploying disaster recovery event to ensure the setup is in working condition. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Thank You very much for your support. I will implement sp_help_revlogin.
Thanks once again. Nagesh