Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Create contained availability group #8713

Closed
thewaiting28 opened this issue Jan 5, 2023 · 6 comments · Fixed by #9352
Closed

Create contained availability group #8713

thewaiting28 opened this issue Jan 5, 2023 · 6 comments · Fixed by #9352
Labels
feature smo will not support Unable to support this or unwilling to for various reasons

Comments

@thewaiting28
Copy link

Summarize Functionality

Would love to be able to create new contained availability group, either with New-DbaAvailabilityGroup or a new command? Also query whether or not an AG is contained. Thank you!

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

Something like "New-DbaAvailabilityGroup -Primary sql01\inst01 -Secondary sql02\inst02 -Name "ag01" -Database "Database01" -Contained $true

Or, -Contained just as a switch
@thewaiting28 thewaiting28 added feature triage required New issue that has not been reviewed by maintainers labels Jan 5, 2023
@wsmelton
Copy link
Member

wsmelton commented Jan 7, 2023

Contained Availability Group is a SQL Server 2022 only feature. At a minimum this cannot be implemented until we are using SMO version that supports full SQL Server 2022 compatibility in the dbatools.library.

Not a priority right now but if anyone would like to submit a PR post 2.0 release, we are happy to review and accept.

@wsmelton wsmelton added help appreciated If you have time to swing by and submit a PR to fix some things, we would greatly appreciate it smo will not support Unable to support this or unwilling to for various reasons and removed triage required New issue that has not been reviewed by maintainers help appreciated If you have time to swing by and submit a PR to fix some things, we would greatly appreciate it labels Jan 7, 2023
@wsmelton
Copy link
Member

wsmelton commented Jan 7, 2023

Quick check in SMO the preview release does not show support of this as of yet. I'm not sure if sqlserver module is supporting this already.

At this time, we can't support it but will leave the issue open until we find SMO can support it.

@thewaiting28
Copy link
Author

Thank you!

@DorBreger
Copy link
Contributor

Hi, what is the status on this? It seems that the SMO does support contained AGs. It's just not documented as of yet.
microsoft/sqlmanagementobjects#154
Would really love to see this feature implemented.

@serenefiresiren
Copy link
Contributor

I have a solution for this I developed and tested for my own environment. I'll get that posted shortly.

@serenefiresiren serenefiresiren mentioned this issue May 11, 2024
Merged
10 tasks
@andreasjordan andreasjordan mentioned this issue May 15, 2024
Merged
10 tasks
@DorBreger
Copy link
Contributor

@thewaiting28 looks like you can stop waiting

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature smo will not support Unable to support this or unwilling to for various reasons
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

New-DbaAvailabilityGroup: Add support for contained availability groups DorBreger/dbatools
4 participants
@wsmelton @thewaiting28 @DorBreger @serenefiresiren