< Back
Get-AzureRmSqlDatabaseGeoBackup
Post
NAME Get-AzureRmSqlDatabaseGeoBackup
SYNOPSIS
Gets a geo-redundant backup of a database.
SYNTAX
Get-AzureRmSqlDatabaseGeoBackup [-ResourceGroupName] <String> [-ServerName] <String> [[-DatabaseName] <String>] [-DefaultProfile
<IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRMSqlDatabaseGeoBackup cmdlet gets a specified geo-redundant backup of a SQL database or all available geo-redundant backups on a
specified server.
A geo-redundant backup is a restorable resource using data files from a separate geographic location. You can use Geo-Restore to restore a
geo-redundant backup in the event of a regional outage to recover your database to a new region.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database to get.
Required? false
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 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 server that hosts the backup to restore.
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
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Backup.Model.AzureSqlDatabaseGeoBackupModel
NOTES
Example 1: Get all geo-redundant backups on a server
PS C:\\>Get-AzureRMSqlDatabaseGeoBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer"
This command gets all available geo-redundant backups on a specified server.
Example 2: Get a specified geo-redundant backup
PS C:\\>Get-AzureRMSqlDatabaseGeoBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer" -DatabaseName "ContosoDatabase"
This command gets the database geo-redundant backup named ContosoDatabase.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... egeobackup
Overview: Cloud business continuity and database disaster recovery with SQL Database http://go.microsoft.com/fwlink/?LinkId=746881
Recover an Azure SQL Database from an outage http://go.microsoft.com/fwlink/?LinkId=746882
Restore-AzureRmSqlDatabase
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Gets a geo-redundant backup of a database.
SYNTAX
Get-AzureRmSqlDatabaseGeoBackup [-ResourceGroupName] <String> [-ServerName] <String> [[-DatabaseName] <String>] [-DefaultProfile
<IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRMSqlDatabaseGeoBackup cmdlet gets a specified geo-redundant backup of a SQL database or all available geo-redundant backups on a
specified server.
A geo-redundant backup is a restorable resource using data files from a separate geographic location. You can use Geo-Restore to restore a
geo-redundant backup in the event of a regional outage to recover your database to a new region.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database to get.
Required? false
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 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 server that hosts the backup to restore.
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
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Backup.Model.AzureSqlDatabaseGeoBackupModel
NOTES
Example 1: Get all geo-redundant backups on a server
PS C:\\>Get-AzureRMSqlDatabaseGeoBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer"
This command gets all available geo-redundant backups on a specified server.
Example 2: Get a specified geo-redundant backup
PS C:\\>Get-AzureRMSqlDatabaseGeoBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer" -DatabaseName "ContosoDatabase"
This command gets the database geo-redundant backup named ContosoDatabase.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... egeobackup
Overview: Cloud business continuity and database disaster recovery with SQL Database http://go.microsoft.com/fwlink/?LinkId=746881
Recover an Azure SQL Database from an outage http://go.microsoft.com/fwlink/?LinkId=746882
Restore-AzureRmSqlDatabase
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/