Groups | Blog | Home
all groups > sql server (alternate) > may 2004 >

sql server (alternate) : Log Shipping for replication


trp24 NO[at]SPAM hotmail.com
5/21/2004 1:02:54 PM
I need to implement a dirt cheap replication method for some dirt
cheap servers. We are using the SQL Server workgroup license. Is
there anything in this that prevents using log shipping for
replication in Workgroup versus Enterprise?

Thanks
Simon Hayes
5/23/2004 7:01:06 PM

[quoted text, click to view]

I'm not sure what you mean by a "SQL Server workgroup license" - perhaps you
mean you're using MSSQL in a workgroup, rather than in a domain? In any
case, log shipping requires copying files from one server's filesystem to
another, so you would need to use service accounts which have those
permissions.

Apart from that, there are other options, including rolling your own
solution:

http://sqlguy.home.comcast.net/logship.htm
http://www.sql-server-performance.com/sql_server_log_shipping.asp

MSSQL replication might also be a possibility, depending on what you're
trying to achieve, but it's not really viable to build any sort of "dirt
cheap" highly available system, if only because of operations costs, ie.
making sure there is always someone there to respond when you need them.

Simon

AddThis Social Bookmark Button