SQL Server Performance

Login transfer in Log shipping process

Discussion in 'SQL Server Log Shipping' started by mahi, Jan 5, 2006.

  1. mahi New Member

    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
  2. SQLDBcontrol New Member

    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
  3. satya Moderator

Share This Page