< Back

Get-AzureRmSqlDeletedDatabaseBackup

Tue Jan 29, 2019 10:08 pm

NAME Get-AzureRmSqlDeletedDatabaseBackup



SYNOPSIS

Gets a deleted database that you can restore.





SYNTAX

Get-AzureRmSqlDeletedDatabaseBackup [-ResourceGroupName] <String> [-ServerName] <String> [[-DatabaseName] <String>] [[-DeletionDate] <DateTime>]

[-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Get-AzureRMSqlDeletedDatabaseBackup cmdlet gets a specified deleted SQL database backup that you can restore, or all deleted backups that you

can restore.



This cmdlet is also supported by the SQL Server Stretch Database service on Azure.





PARAMETERS

-DatabaseName <String>

Specifies the name of the database.



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



-DeletionDate <DateTime>

Specifies the date, as a DateTime object, that the database was deleted. To get a DateTime object, use the Get-Date cmdlet.



Required? false

Position? 3

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of the resource group to which the 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 database server.



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



NOTES









Example 1: Get all deleted database backups on a server



PS C:\\>Get-AzureRMSqlDeletedDatabaseBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer"



This command gets all deleted database backups on a server.





Example 2: Get a specified deleted database backup



PS C:\\>Get-AzureRMSqlDeletedDatabaseBackup -ResourceGroupName "ContosoResourceGroup" -ServerName "ContosoServer" -DatabaseName "ContosoDatabase"



This command gets the deleted database backup for ContosoDatabase.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... basebackup

Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy

SQL Database Documentation https://docs.microsoft.com/azure/sql-database/