2

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 this link.

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?

Improve this question
2
  • 1
    It is totally ok and allowed and you should be able to restore without any issue.
    – Shanky
    Commented Jul 3, 2020 at 11:38
  • 1
    Thank you. I've restored the master db and everything seems to be restored now. I've followed this manual
    – Masahiko Okajima
    Commented Jul 6, 2020 at 5:02

1 Answer 1

Reset to default
0

To make sure I called up the Microsoft support and they said this might work, but not supported. They suggested not to do it. According to the support guy there are some difference in system databases when clustered or not, and the difference can cause an error, and there are known such cases too. And they gave me this link. So the answer seems to be no.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.