CMS on an AOAG?

Question

Post reply

CMS on an AOAG?

andreas.kreuzberg

SSCertifiable

Points: 6191
More actions
May 31, 2021 at 6:09 am

#3890104

Hello everyone,
is it possible, to put the CMS on a AOAG? We do a lot of maintenance jobs from our CMS, and we are afraid, if the server will crash.
Therefor we thought, if it is possible, to put the CMS on an AOAG. Are there any tricks, or just try it?
We use the CMS for a lot of multi server jobs. It this as well possible to do it within a AOAG?
Thanks for your time and your ideas
Kind regards,
Andreas

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

Isn't CMS hosted in msdb?

You cannot put systems databases in an AOAG.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

andreas.kreuzberg SSCertifiable Points: 6191 More actions · Answer 2

Hi,

I think, it was to early for this post. You are right, so it is impossible.

I had to think about it, how I can backup my configuration. Maybe dbatools are an otpion.

Thanks for your reply.

Andreas

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

https://dbatools.io/cms/

Clear-Host

$TargetPath = 'c:\SQL_CMS_Export'

Export-DbaRegServer -SqlInstance Your_CMS_SQLInstance -Path $TargetPath
 

explorer.exe "$TargetPath"

<# Results

Your_CMS_SQLInstance-reggroup-DatabaseEngineServerGroup-06022021131433.xml

#>

This reply was modified 3 years, 5 months ago by Johan Bijnens.