May 31, 2021 at 6:09 am
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
May 31, 2021 at 12:02 pm
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
May 31, 2021 at 12:13 pm
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
June 2, 2021 at 10:59 am
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
#>
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply