< Back
New-AzureRmSqlDatabaseRestorePoint
Post
NAME New-AzureRmSqlDatabaseRestorePoint
SYNOPSIS
Creates a new restore point from which a SQL Database can be restored.
SYNTAX
New-AzureRmSqlDatabaseRestorePoint [-ResourceGroupName] <String> [-ServerName] <String> [-DatabaseName] <String> [-DefaultProfile
<IAzureContextContainer>] -RestorePointLabel <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The New-AzureRmSqlDatabaseRestorePoint cmdlet creates a new restore point that an Azure SQL Database can be restored from.
This cmdlet is currently supported by the SQL Server Datawarehouse service on Azure SQL Database.
PARAMETERS
-DatabaseName <String>
Specifies the name of the SQL Database.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-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
-ResourceGroupName <String>
Specifies the name of the resource group to which the SQL Database is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-RestorePointLabel <String>
Specifies the label of the restore point for easy identification.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the AzureSQL Server that hosts the database.
Required? true
Position? 1
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
OUTPUTS
NOTES
Example 1: Create a restore point
PS C:\\>New-AzureRmSqlDatabaseRestorePoint -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
-RestorePointLabel "RestorePoint01"
ResourceGroupName : resourcegroup01
ServerName : server01
DatabaseName : database01
Location : Central US
RestorePointType : DISCRETE
RestorePointCreationDate : 8/12/2015 12:00:00 AM
EarliestRestoreDate :
RestorePointLabel : RestorePoint01
This command creates a restore point for Azure SQL Database and returns the details of the restore point.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... storepoint
SYNOPSIS
Creates a new restore point from which a SQL Database can be restored.
SYNTAX
New-AzureRmSqlDatabaseRestorePoint [-ResourceGroupName] <String> [-ServerName] <String> [-DatabaseName] <String> [-DefaultProfile
<IAzureContextContainer>] -RestorePointLabel <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The New-AzureRmSqlDatabaseRestorePoint cmdlet creates a new restore point that an Azure SQL Database can be restored from.
This cmdlet is currently supported by the SQL Server Datawarehouse service on Azure SQL Database.
PARAMETERS
-DatabaseName <String>
Specifies the name of the SQL Database.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-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
-ResourceGroupName <String>
Specifies the name of the resource group to which the SQL Database is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-RestorePointLabel <String>
Specifies the label of the restore point for easy identification.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the AzureSQL Server that hosts the database.
Required? true
Position? 1
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
OUTPUTS
NOTES
Example 1: Create a restore point
PS C:\\>New-AzureRmSqlDatabaseRestorePoint -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
-RestorePointLabel "RestorePoint01"
ResourceGroupName : resourcegroup01
ServerName : server01
DatabaseName : database01
Location : Central US
RestorePointType : DISCRETE
RestorePointCreationDate : 8/12/2015 12:00:00 AM
EarliestRestoreDate :
RestorePointLabel : RestorePoint01
This command creates a restore point for Azure SQL Database and returns the details of the restore point.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... storepoint