Clever Geek Handbook

SQL Server Compact Edition - Multiple Subscription Issues

I have a SQL Server 2008 database successfully replicating to Windows Database for Windows with a filter subscription. This works great.

However, if my 2008 database goes down, my mobile will no longer replicate. What I want to do is crash on the SQL server, which if subscription 1 doesn't sync, I can call the second subscription on server 2 at a different web address.

However, I cannot add the add subscription because there is already a subscription to the primary DB and like the same tables.

Any idea if this can be done and if this is not the best way to deal with a fault tolerant server for replication purposes.

+2


source to share


1 answer


There is no backup across servers via synchronization. You will need to set up a SQL Server cluster and perform an initial synchronization with the cluster.



The database on another server cannot be provisioned because triggers and tombstone tables will be out of date. I don't think they are replicated by default.

+1


source






More articles:


All Articles