Login transfer in Log shipping process | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login transfer in Log shipping process

Hi, Any body please explain me how the logins will be tranfer from primary
to secondary server in log shipping process. When ever the primary server
is down then the secondary server will be made up manually, at this moment we
cant do any DTS process and the microsoft script to execute in primary server.
if there are very less orphand user we can go manually but if there are many
logins how we transfer. In log shiping process is login transfer is automated while logs are shipping to secondary server? Mahi

Hi, Logins are not transferred as part of the log shipping process so you must do this yourself, before your primary server goes down, and if necessary, set up a regularly scheduled job that does this for you.
quote:Originally posted by mahi Hi, Any body please explain me how the logins will be tranfer from primary
to secondary server in log shipping process. When ever the primary server
is down then the secondary server will be made up manually, at this moment we
cant do any DTS process and the microsoft script to execute in primary server.
if there are very less orphand user we can go manually but if there are many
logins how we transfer. In log shiping process is login transfer is automated while logs are shipping to secondary server? Mahi

Karl Grambow www.sqldbcontrol.com
It is because the logins are stored in master database and only you deliver log shipping for user databases, in order to achieve you must use DTS jobs as specified inhttp://www.sql-server-performance.com/q&a35.asp and Technet http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx]. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>