After just getting a new phone and watching the slow restore time for my sms messages, I decided it was time have a bit of a tidy up.

I was upgrading a SQL 2012 instance to SQL 2016 and the upgrade failed with the error shown below.

Applying cumulative updates to SQL Servers remotely using PowerShell.

Partition switching fails with error 4947, level 16, State 1

You can start SQL Server Configuration Manager locally to connect to a remote SQL Server using the registered server list in SSMS.