SQL Provider.

MSSQL vs. MySQL?

[Dabrowski]

ok,

I have a database system that's growing rapidly. That's not the problem, the problem is I want to replicate the server for fault tolerance.

I'm running 2x MS SBS Server, which comes with MSSQL, but I believe a limited version of it. I don't know the limitations as I downloaded the free MySQL and have been using that instead.

Anyone know if the MSSQL that comes with SBS supports replication? The full versions of both are expensive, and I'd rather not have to spend on them if need be.

I've got the DNS, IIS config and the actual files all sync'd nicely, just need the DB to fall into line.

[FalseDawn]

SBS comes with the workgroup edition of MSSQL, which supports limited replication features, although the number of clients is limited.
SQL Server database mirroring is a _much_ nicer solution, but as you say, you'll have to pay for the convenience.

[Dabrowski]

Thanks for the reply Falsedawn. I did the research and came up with the same conclusion unfortunately.

I'll stick with my single installation for now, until I have a spare £1,500 per year!