SQL Server Performance

Security account for log shipping in cluster environment

Discussion in 'SQL Server 2005 Log Shipping' started by arka, Nov 4, 2011.

  1. arka New Member

    We need to set up a log shipping for SQL-2005 SP3 instance in clustered environment to DR server. The cluster and DR are in absolutely different domains that don’t know about each other.

    My question is what account I should use to set up the log shipping? I cannot use local SQL Agent service account because the cluster is running under domain account (and my understanding is that it must be under domain, no other choice). On the other hand the DR doesn't recognize this domain. So what is the solution to this?

    Thank you all in advance.
    arka, Nov 4, 2011
    #1

  2. satya Moderator

    Welcome to the forums.
    First of all I suggest to test and apply Service Pack4 on your SQL2005 instance, SP4 is last and latest for this version.
    Coming to the solution you might create a login such LogShip on both the server instances with the same name and password/privleges then setup manual log shipping between these 2 instances.
    satya, Nov 22, 2011
    #2

Share This Page