I have to upgrade version of SQL for my PI system.
Current version:SQL Server 2012
Version that will be installed: SQL Service Pak 2 SQL Server 2012
I would ask you:
1) Do you know any incompatibility with this upgrade?
2) For a collective system, wich is the best practice to install the software (primary first, secondary first,...)?
3) Is necessary a machine restart after the installation? In case, which is the correct machines order for the restart?
Best Regards and thanks in advance for your help.