I’m converting WSFC fail-over clustered SQL Server 2012 instance into non-clustered one.
My question in short: Is it OK to restore a master database backup taken from the clustered instance, into the newly installed un-clustered instance?
To achieve the conversion I’ve followed the instruction in this link:
Basically I’ve removed all the nodes from the cluster, remove the cluster, re-install standalone SQL Server, then re-mount the previously shared NTFS volume locally and attached all user databases.
Then, I’ve transferred logins using sp_help_revlogin, linked servers, jobs, server roles, some permissions as shown in the link below.
But still some things were missing from the re-installed instance, like permissions for system procedures, and these were stored in the master db.
Is it OK to restore the entire master db from the old clustered instance, or do I need to avoid such restore when some server configuration was changed, in my case un-clustered?