< Back
Remove-AzureRmSqlServerAuditing
Post
NAME Remove-AzureRmSqlServerAuditing
SYNOPSIS
Removes the auditing of a SQL server.
SYNTAX
Remove-AzureRmSqlServerAuditing [-ResourceGroupName] <String> [-DefaultProfile <IAzureContextContainer>] [-PassThru] -ServerName <String>
[-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Remove-AzureRmSqlServerAuditing cmdlet removes the auditing of an Azure SQL server. To use this cmdlet, specify the ResourceGroupName and
ServerName parameters to identify the server. After you run this cmdlet, auditing of the databases on the Azure SQL server is not performed. If
the command succeeds, and you specify the PassThru parameter, the cmdlet returns an object that describes the current auditing policy and the
Azure SQL server identifiers. Server identifiers include the ResourceGroupName and ServerName .
PARAMETERS
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the Azure SQL server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the Azure SQL server.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.Azure.Commands.Sql.Security.Model.ServerAuditingPolicyModel
OUTPUTS
Microsoft.Azure.Commands.Sql.Security.Model.ServerAuditingPolicyModel
NOTES
Example 1: Remove the auditing of an Azure SQL server
PS C:\\>Remove-AzureRmSqlDatabaseAuditing -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
This command removes the auditing of all the databases located on Server01 in resource group.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... erauditing
Get-AzureRmSqlDatabaseAuditingPolicy
Set-AzureRmSqlDatabaseAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Removes the auditing of a SQL server.
SYNTAX
Remove-AzureRmSqlServerAuditing [-ResourceGroupName] <String> [-DefaultProfile <IAzureContextContainer>] [-PassThru] -ServerName <String>
[-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Remove-AzureRmSqlServerAuditing cmdlet removes the auditing of an Azure SQL server. To use this cmdlet, specify the ResourceGroupName and
ServerName parameters to identify the server. After you run this cmdlet, auditing of the databases on the Azure SQL server is not performed. If
the command succeeds, and you specify the PassThru parameter, the cmdlet returns an object that describes the current auditing policy and the
Azure SQL server identifiers. Server identifiers include the ResourceGroupName and ServerName .
PARAMETERS
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the Azure SQL server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the Azure SQL server.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.Azure.Commands.Sql.Security.Model.ServerAuditingPolicyModel
OUTPUTS
Microsoft.Azure.Commands.Sql.Security.Model.ServerAuditingPolicyModel
NOTES
Example 1: Remove the auditing of an Azure SQL server
PS C:\\>Remove-AzureRmSqlDatabaseAuditing -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
This command removes the auditing of all the databases located on Server01 in resource group.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... erauditing
Get-AzureRmSqlDatabaseAuditingPolicy
Set-AzureRmSqlDatabaseAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/