< Back

Disable-DbaAgHadr

Mon Jan 13, 2020 9:43 am

NAME Disable-DbaAgHadr



SYNOPSIS

Disables the Hadr service setting on the specified SQL Server.





SYNTAX

Disable-DbaAgHadr [-SqlInstance] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]> [[-Credential]

<Pscredential>] [-Force <Switch>] [-EnableException <Switch>] [<CommonParameters>]





DESCRIPTION

In order to build an AG a cluster has to be built and then the Hadr enabled for the SQL Server



service. This function disables that feature for the SQL Server service.





PARAMETERS

-Credential [<Pscredential>]

Credential object used to connect to the Windows server as a different user



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-EnableException [<Switch>]

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.

This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables

advanced scripting.

Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own

try/catch.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-Force [<Switch>]

Will restart SQL Server and SQL Server Agent service to apply the change.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-SqlInstance [<Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>]

The target SQL Server instance or instances.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



NOTES





Tags: AvailabilityGroup, HA, AG

Author: Shawn Melton (@wsmelton), http://wsmelton.github.io



Website: https://dbatools.io

Copyright: (c) 2018 by dbatools, licensed under MIT

License: MIT https://opensource.org/licenses/MIT



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Disable-DbaAgHadr -SqlInstance sql2016



Sets Hadr service to disabled for the instance sql2016 but changes will not be applied until the next time the

server restarts.

-------------------------- EXAMPLE 2 --------------------------



PS C:\\>Disable-DbaAgHadr -SqlInstance sql2016 -Force



Sets Hadr service to disabled for the instance sql2016, and restart the service to apply the change.

-------------------------- EXAMPLE 3 --------------------------



PS C:\\>Disable-DbaAgHadr -SqlInstance sql2012\\dev1 -Force



Sets Hadr service to disabled for the instance dev1 on sq2012, and restart the service to apply the change.



RELATED LINKS

https://dbatools.io/Disable-DbaAgHadr