"T.Paakki" <tr***@hotmail.com> wrote in message
news:63**************************@posting.google.c om...
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
Travis
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.co...g_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