Start-AzSqlInstanceDatabaseLogReplay

Referência

Módulo:: Az.Sql

Inicia um serviço Log Replay com os parâmetros fornecidos.

Syntax

Start-AzSqlInstanceDatabaseLogReplay
     -StorageContainerUri <String>
     -StorageContainerSasToken <String>
     [-AutoCompleteRestore]
     [-LastBackupName <String>]
     [-Collation <String>]
     [-StorageContainerIdentity <String>]
     [-AsJob]
     [-Name] <String>
     [-InstanceName] <String>
     [-ResourceGroupName] <String>
     [-PassThru]
     [-DefaultProfile <IAzureContextContainer>]
     [-WhatIf]
     [-Confirm]
     [<CommonParameters>]

Start-AzSqlInstanceDatabaseLogReplay
     -StorageContainerUri <String>
     -StorageContainerSasToken <String>
     [-AutoCompleteRestore]
     [-LastBackupName <String>]
     [-Collation <String>]
     [-StorageContainerIdentity <String>]
     [-AsJob]
     [-PassThru]
     [-InputObject] <AzureSqlManagedDatabaseModel>
     [-DefaultProfile <IAzureContextContainer>]
     [-WhatIf]
     [-Confirm]
     [<CommonParameters>]

Description

O cmdlet Start-AzSqlInstanceDatabaseLogReplay inicia o início do serviço de repetição de log.

Exemplos

Exemplo 1

Start-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -Name "ManagedDatabaseName" `
	-Collation "SQL_Latin1_General_CP1_CI_AS" -StorageContainerUri "https://test.blob.core.windows.net/testing" `
	-StorageContainerSasToken "sv=2019-02-02&ss=b&srt=sco&sp=rl&se=2023-12-02T00:09:14Z&st=2019-11-25T16:09:14Z&spr=https&sig=92kAe4QYmXaht%2Fgjocqwerqwer41s%3D" `
	-AutoCompleteRestore -LastBackupName "last_backup.bak"

Esse comando criará um novo banco de dados gerenciado e começará a restaurar backups do contêiner fornecido até que last_backup.bak seja restaurado.

Exemplo 2

Start-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -Name "ManagedDatabaseName" `
	-Collation "SQL_Latin1_General_CP1_CI_AS" -StorageContainerUri "https://test.blob.core.windows.net/testing" `
	-StorageContainerSasToken "sv=2019-02-02&ss=b&srt=sco&sp=rl&se=2023-12-02T00:09:14Z&st=2019-11-25T16:09:14Z&spr=https&sig=92kAe4QYmXaht%2Fgjocqwerqwer41s%3D"

Esse comando criará um novo banco de dados gerenciado e começará a restaurar backups do contêiner fornecido até que Complete-AzSqlInstanceDatabaseLogReplay seja chamado com o último backup desejado.

Exemplo 3

Start-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -Name "ManagedDatabaseName" `
	-StorageContainerIdentity ManagedIdentity -StorageContainerUri "https://test.blob.core.windows.net/testing"

Inicia um serviço Log Replay com identidade de contêiner especificada como ManagedIdentity. Nesse caso, não há necessidade de especificar o parâmetro StorageContainerSasToken.

Exemplo 4

Start-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -Name "ManagedDatabaseName" `
	-StorageContainerIdentity SharedAccessSignature -StorageContainerUri "https://test.blob.core.windows.net/testing" `
	-StorageContainerSasToken "sv=2019-02-02&ss=b&srt=sco&sp=rl&se=2023-12-02T00:09:14Z&st=2019-11-25T16:09:14Z&spr=https&sig=92kAe4QYmXaht%2Fgjocqwerqwer41s%3D"

Inicia um serviço Log Replay com identidade de contêiner especificada como SharedAccessSignature. O parâmetro StorageContainerSasToken é necessário.

Parâmetros

-AsJob

Executar cmdlet em segundo plano

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoCompleteRestore

O indicador se a restauração deve ou não ser concluída automaticamente após a conclusão.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Collation

O agrupamento do banco de dados de instância a ser usado.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

Solicita sua confirmação antes de executar o cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

As credenciais, a conta, o locatário e a assinatura usados para a comunicação com o Azure.

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-InputObject

O objeto de banco de dados de instância.

Type:	AzureSqlManagedDatabaseModel
Aliases:	InstanceDatabase
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-InstanceName

O nome da instância.

Type:	String
Aliases:	ManagedInstanceName
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-LastBackupName

O nome do último arquivo de backup a ser restaurado.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

O nome do banco de dados de instância.

Type:	String
Aliases:	InstanceDatabaseName
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-PassThru

Define se retorna o grupo de sincronização.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

O nome do grupo de recursos.

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-StorageContainerIdentity

O tipo de identidade a ser usado para o contêiner de armazenamento.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageContainerSasToken

O token Sas do contêiner de armazenamento.

Type:	String
Aliases:	SasToken
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageContainerUri

O URI do contêiner de armazenamento.

Type:	String
Aliases:	Storage
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Mostra o que aconteceria se o cmdlet fosse executado. O cmdlet não é executado.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Entradas

String

AzureSqlManagedDatabaseModel

Saídas