I need to setup database replication (for high availability) on a database that uses FileStream. This is on SQL Server 2012 Standard Edition, so Always On or Peer-to-Peer replication is not an option. Also, database mirroring does not work with FileStream.
The only option I have left is transactional or merge replication. I have found that both replication types work fine when all machines are on, but what happens if one machine is off?
This is what I have (servers run on Microsoft Azure as virtual machines):
- Server A is DC server
- Server B is SQL Server 2012 Standard and Application server (IIS)
- Server C is SQL Server 2012 Standard and Application server (IIS)
Microsoft performs maintenance at least once a month, where at most one of the servers is turned off each time. How can I set up replication with these machines so I can achieve HA when one server is down?