SQL Server Performance

Log shipping on shared environment

Discussion in 'SQL Server Log Shipping' started by business_domain, Mar 23, 2004.

  1. business_domain New Member

    I am currently running a site on a shared environment with sql db. The account is with verio.com: Windows Server 2003m SQL 2000.

    What we would like to do is create a back up site with a backup db. I would like this functionality so that in the event of a crash, while the current site is being repaired, or if the server is down for a prolonged period, I can simply switch to the backup site w/ db.

    I t sounds like log shipping could work, however can I pull that off in a shared environment, even if I have to get a second account?

  2. satya Moderator

    I don't see any issue in deploying Log shipping in shared environment.
    Can you explain bit more about your doubt in second account.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. bj007 New Member

    I have 2 domains, one in US and one in UK. They are both seperate trees.

    I need to configure Log Shipping from UK to US. I have done LS within domains. What needs to be done to accomplish this ?
    How will I be able to see the secondary server from the primary ? What kind of accounts needs to be setup ? Is there some some documentation that you can point to ?
    Thanks
    bj
  4. satya Moderator

    Can both domains see each other on the network?
    Ensure the two-way trust is enabled.
    As usual domain account with required privileges has to be used to perform the log shipping and also consider the size of Transaction log backup in order to reduce any contention in file transfer.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page