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.
