VENDAS: 1-800-867-1389
EN
Este conteúdo não está disponível em seu idioma, mas aqui está a versão em inglês.

Get-AzureSqlRecoverableDatabase

Get-AzureSqlRecoverableDatabase

Gets a list of databases that can be recovered.

Syntax

Parameter Set: AllDatabasesOnGivenServer
Get-AzureSqlRecoverableDatabase -ServerName <String> [ <CommonParameters>]

Parameter Set: GivenDatabaseObject
Get-AzureSqlRecoverableDatabase -Database <RecoverableDatabase> [ <CommonParameters>]

Parameter Set: GivenDatabaseOnGivenServer
Get-AzureSqlRecoverableDatabase -DatabaseName <String> -ServerName <String> [ <CommonParameters>]




Detailed Description

This cmdlet returns a specific recoverable database, or a list of all recoverable databases, from a specific server.

Parameters

-Database<RecoverableDatabase>

The database object representing the database you want to retrieve.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByValue)

Accept Wildcard Characters?

false

-DatabaseName<String>

The name of the database you want to retrieve.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServerName<String>

The name of the server to retrieve the recoverable database(s) from.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see  about_CommonParameters (http://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • Microsoft.WindowsAzure.Management.Sql.Models.RecoverableDatabase

Outputs

The output type is the type of the objects that the cmdlet emits.

  • IEnumerable<Microsoft.WindowsAzure.Management.Sql.Models.RecoverableDatabase>

Notes

  • You must use certificate based authentication to run this cmdlet. The following commands need to be run to on the computer you are using to run the command from:
    C:\PS>$subId = <Subscription ID>
    C:\PS>$thumbprint = <Certificate Thumbprint>
    C:\PS>$myCert = Get-Item Cert:\CurrentUser\My\$thumbprint
    C:\PS>Set-AzureSubscription -SubscriptionName "mySubscription" -SubscriptionId $subId -Certificate $myCert
    C:\PS>Select-AzureSubscription -SubscriptionName "mySubscription"

Examples

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

This example lists all recoverable databases on "server1".


PS C:\>Get-AzureSqlRecoverableDatabase –ServerName "server1"

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

This example retrieves the specific database "mydb" on "server1".


PS C:\>Get-AzureSqlRecoverableDatabase -ServerName "server1" -DatabaseName "mydb"


Related topics

Isso foi útil para você?
(1500 caracteres restantes)
Agradecemos os seus comentários
Mostrar:
© 2014 Microsoft