SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:58 AM
| ||||
| ||||
 Log Shipping for replication 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      |
|
02-29-2008, 02:59 AM
| ||||
| ||||
| Re: Log Shipping for replication "T.Paakki" <trp24@hotmail.com> wrote in message news:6358a14b.0405211202.70d39540@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 |
Linear Mode
