We have two
SQL Server 2016 Standard edition (standard edition due to budget issues) configured one as
primary sql server and another one as
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 ?