Export and Import | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export and Import

Hi 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