SQL Server Performance Forum – Threads Archive

log shipping w/out domain accounts?

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

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.

]]>