SQLCurious - Thursday, March 8, 2018 9:29 AM

SQL Server version 11.0.3460.0 and SQL Server version 11.0.3153.0

Hello,

We have an "Always On" setup with Node-1 and Node-2 (with synhronous commit) in our primary location and Node-3 in a DR location (with asynhronous commit). This whole setup is using SQL Server 2012 servers. While Node-1 and Node-2 are on version 11.0.3460.0, Node-3 is on 11.0.3153.0. The service pack update was somehow missed on Node-3, apparently. Now we have a DR exercise coming up tomorrow night and we are expected to make Node-03 primary and leave it there for 3 to 4 days. Our previous attempts to check this setup ran successfully although we only did sanity tests and swung right back to make Node-1 primary. Unfortunately we do not have downtime to apply the patch on Node-3 to bring all SQL server minor versions on par. What risks should I be anticipating with this setup? If anyone else here had similar experience, I would appreciate if you could share it.

Sincerely,
SQLCurious