We have two SQL Server 2016 Standard edition
(standard edition due to budget issues) configured one as primary sql server
and another one as fail-over server
.
I have implemented Transactional replication
from primary to secondary server.
To do some maintenance and patching in primary,we have decided to do failover to the other server.But since SQL Server is standard edition
,we have no other option but to break replication.I know that Replication
is not a Failover solution.
Anyways after patching/maintenance is done we will switch the application back to primary server.But to bring the records which went to failovr server i am thinking to implement Log shipping
.So i will restore a latest backup from fail-over to primary and then implement log shipping to synch with the data.
I don't get huge maintenance window in between,that is why i have to do this way. Do you think this plan will work ?