{"action":"closed","issue":{"url":"https://api.github.com/repos/PowerShell/xSharePoint/issues/176","repository_url":"https://api.github.com/repos/PowerShell/xSharePoint","labels_url":"https://api.github.com/repos/PowerShell/xSharePoint/issues/176/labels{/name}","comments_url":"https://api.github.com/repos/PowerShell/xSharePoint/issues/176/comments","events_url":"https://api.github.com/repos/PowerShell/xSharePoint/issues/176/events","html_url":"https://github.com/PowerShell/xSharePoint/issues/176","id":132598823,"number":176,"title":"Add support for AlwaysOn Availability Group enrollment for databases","user":{"login":"BrianFarnhill","id":1332611,"avatar_url":"https://avatars.githubusercontent.com/u/1332611?v=3","gravatar_id":"","url":"https://api.github.com/users/BrianFarnhill","html_url":"https://github.com/BrianFarnhill","followers_url":"https://api.github.com/users/BrianFarnhill/followers","following_url":"https://api.github.com/users/BrianFarnhill/following{/other_user}","gists_url":"https://api.github.com/users/BrianFarnhill/gists{/gist_id}","starred_url":"https://api.github.com/users/BrianFarnhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrianFarnhill/subscriptions","organizations_url":"https://api.github.com/users/BrianFarnhill/orgs","repos_url":"https://api.github.com/users/BrianFarnhill/repos","events_url":"https://api.github.com/users/BrianFarnhill/events{/privacy}","received_events_url":"https://api.github.com/users/BrianFarnhill/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/PowerShell/xSharePoint/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/PowerShell/xSharePoint/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"closed","locked":false,"assignee":{"login":"BrianFarnhill","id":1332611,"avatar_url":"https://avatars.githubusercontent.com/u/1332611?v=3","gravatar_id":"","url":"https://api.github.com/users/BrianFarnhill","html_url":"https://github.com/BrianFarnhill","followers_url":"https://api.github.com/users/BrianFarnhill/followers","following_url":"https://api.github.com/users/BrianFarnhill/following{/other_user}","gists_url":"https://api.github.com/users/BrianFarnhill/gists{/gist_id}","starred_url":"https://api.github.com/users/BrianFarnhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrianFarnhill/subscriptions","organizations_url":"https://api.github.com/users/BrianFarnhill/orgs","repos_url":"https://api.github.com/users/BrianFarnhill/repos","events_url":"https://api.github.com/users/BrianFarnhill/events{/privacy}","received_events_url":"https://api.github.com/users/BrianFarnhill/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-02-10T03:31:28Z","updated_at":"2016-02-20T04:04:53Z","closed_at":"2016-02-20T04:04:53Z","body":"A DSC resource could be used to facilitate putting SharePoint databases in to specific AlwaysOn Availability groups in SQL server through the use of the Add-DatabaseToAvailabilityGroup cmdlet (which is part of the Microsoft.SharePoint.PowerShell snapin, thus why we'll look to add this here and not in xSql). An example structure for this resource:\r\n\r\n    xSPAAGConfiguration ConfigDBAAG {\r\n        DatabaseName = \"SP_Config\"\r\n        AGName = \"MyAvailabilityGroup\"\r\n        FileShare = \"\\\\SQL\\Backups\"\r\n    }\r\n\r\nAn alternative could be to enrol all databases:\r\n\r\n    xSPAAGConfiguration AAGSetup {\r\n        EnrollAllDatabases = $true\r\n        AGName = \"MyAvailabilityGroup\"\r\n        FileShare = \"\\\\SQL\\Backups\"\r\n    }"}}