SQL Server Performance

log shipping w/out domain accounts?

Discussion in 'SQL Server Log Shipping' started by kcollins, Feb 12, 2004.

  1. kcollins New Member

    Is it possible to setup log shipping without having domain accounts?

    I'm setting up a network of four servers -- two database and two web -- and I want to set up one of each as warm standby servers. These will be running Win2K server and SQL Server 2000 Standard.

    The article athttp://www.sql-server-performance.com/sql_server_log_shipping.asp recommends using NT Authentication to sync the logins. However, I've been advised that running Active Directory for a four-server network would be overkill.

    How can I create a log shipping solution to keep the standby SQL box in sync with production without creating a domain?

    Thanks
  2. satya Moderator

    Without the domain account privilege for SQL service accounts its not possible to setup the LS.
    And SQL 2K standard doesn't include inbuilt log shipping wizard, you need to have Enterprise edition or you can deploy your own LS process as mentioned in the link above.


    Other option is to have an account on both the boxes with the same name and privileges, I'm sure this will work as I haven't tested but in theory it should.

    HTH

    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