I wish to do an in-place upgrade of our current production environment. This will not be rushed as I need to minimise downtime.
We currently have a 2 node cluster, both running Windows 2012 R2 and SQL Server 2014. Both the OS and SQL are patched to the relevant latest version.
I have found this and it is worth a read
I think very broadly the steps are:
1. Drain one node (node B) as described in the link above and clean install Win 2016 on it.
2. Join windows cluster on node A
3. Install SQL 2014 on node B, joining cluster on node A
4. Patch SQL to SP2 CU13
5. Fail over node A to node B
6. Clean install Win 2016 on node A
7. Join windows cluster on node B
8. Install SQL 2014 on node A, joining cluster on node B
9. Patch SQL to SP2 CU13
10. Enable Win 2016 cluster feature, the ‘Point of no return’
11. Do in-place upgrade of SQL to version 2017 at the cluster level (Both nodes at once?)
Has anyone any experience of this? Or any thoughts on my broad approach above?