Продажи: 1-800-867-1389
EN
Данное содержимое не доступно на вашем языке, используйте версию на английском языке.

Get-AzureSqlDatabaseOperation

Updated: August 13, 2015

Get-AzureSqlDatabaseOperation

Gets the status of database operations on an Azure server.

Syntax

Parameter Set: ByConnectionContext
Get-AzureSqlDatabaseOperation [-ConnectionContext] <IServerDataServiceContext> [-Database <Database> ] [-DatabaseName <String> ] [-OperationGuid <Guid> ] [ <CommonParameters>]

Parameter Set: ByServerName
Get-AzureSqlDatabaseOperation [-ServerName] <String> [-Database <Database> ] [-DatabaseName <String> ] [-OperationGuid <Guid> ] [ <CommonParameters>]




Detailed Description

The Get-AzureSqlDatabaseOperation cmdlet gets the status of database operations on the specified Azure server. If you specify only the ServerName or ConnectionContext parameter, the cmdlet gets all the database operations for the server. If you also specify a database by using the Database or DatabaseName parameter, this cmdlet gets all the operations for the specified database. If you specify an operation GUID, and ServerName or ConnectionContext, the cmdlet gets a single database operation.

Parameters

-ConnectionContext<IServerDataServiceContext>

Specifies the connection context of a server.


Aliases

Context

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByValue, ByPropertyName)

Accept Wildcard Characters?

false

-Database<Database>

Specifies an object that represents an Azure SQL Database. If you specify this parameter, you must specify the ServerName parameter or ConnectionContext parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByValue)

Accept Wildcard Characters?

false

-DatabaseName<String>

Specifies the name of a database. If you specify this parameter, you must specify the ServerName parameter or the ConnectionContext parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-OperationGuid<Guid>

Specifies the operation ID that represents a specific database operation for which this cmdlet gets status. You can obtain operation IDs by requesting all the database operations for a Azure SQL Database or server. If you specify this parameter, you must specify the ServerName parameter or the ConnectionContext parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByValue)

Accept Wildcard Characters?

false

-ServerName<String>

Specifies the name of a server.


Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see    about_CommonParameters.

Inputs

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

  • Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.Database
  • Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext
  • System.Guid

Outputs

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

  • Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.Database.DatabaseOperationResponseList[]

    This cmdlet returns an array of DatabaseOperationResponseList objects if you get multiple operations.


  • Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.Database.DatabaseOperationResponse

Examples

Example 1: Get the status of all database operations for a database

This command gets the status of all database operations on the database named Database17 on the server that the connection context $Context specifies.


PS C:\> $Operations = Get-AzureSqlDatabaseOperation -ConnectionContext $Context -DatabaseName "Database17"

Example 2: Get the status of all database operations for a server

This command gets the status of all database operations on the server that the connection context $Context specifies.


PS C:\> $Operations = Get-AzureSqlDatabaseOperation -ConnectionContext $Context

Related topics

Была ли вам полезна эта информация?
(1500 символов осталось)
Спасибо за ваш отзыв
Показ:
© 2015 Microsoft