Hello all,
We have 2 sites . each one has sql 2005 express edition .
is it possible to configure replication between those 2 sql servers for failover purposes ?
ThanksSort of. You should use log shipping for something like this. Note that SQL Server Express does not support replication publishing, ie you can't use merge replication to publish database on a SQL Express installation. You can make them subscribers however.
Nor can you use the log shipping wizard which ships in SQL Server Standard and above.
You will have to roll your own log shipping topology and you will have to do manual failover and redirect your clients to the failover server.
No comments:
Post a Comment