Hi there,
I wanted to know what is the best way to rollback a SQL Server service pack or cumulative update for SQL Server 2014. We have a 2 replica availability group set up using SQL 2014 and are currently on SQL 2014 SP1 CU7. I am planning on upgrading to SQL 2014 SP2 in the next couple of days and wanted to know what the rollback plan should be in case we need to rollback the service pack.
I know the standard process for upgrading a 2 replica SQL 2014 availability group is to apply the SP/CU on the secondary, then failover to the secondary and then apply the SP/CU on the other replica. Does this also apply when uninstalling a SP/CU or is it different?
Thanks,
Avinash