Azure SQL 数据库克隆问题

Question

我正在尝试在同一 Azure SQL 服务器上克隆 Azure SQL 数据库，但存在一些问题。我不知道是什么引起了问题。

$SubscriptionId = "**********"
$SourceResourceGroupName = "rg"
$SourceServerName = "sql"
$SourceDatabaseName = "sql_test"

$TargetResourceGroupName = "rg"
$TargetServerName = "sql"
$TargetDatabaseName = "sql_dev"

$UserName = "*****"
$Password = ConvertTo-SecureString –String "**********" –AsPlainText -Force

$Timestamp = Get-Date -Format "yyyy-MM-dd-hh-mm"
$DatabaseToBackup = $SourceDatabaseName
$StorageUri = "**********"
$BackupDestination = $StorageUri + $DatabaseToBackup + "_" + $Timestamp + ".bacpac"
$StorageAccountName = "**********"

Set-AzContext -Subscription $SubscriptionId

$StorageKey = "**************"

Write-Host $BackupDestination

$export=New-AzSqlDatabaseExport `
    -ResourceGroupName $SourceResourceGroupName `
    -ServerName $SourceServerName `
    -DatabaseName $DatabaseToBackup `
    -UseNetworkIsolation $true `
    -SqlServerResourceIdForPrivateLink "********" `
    -AuthenticationType AdPassword `
    -AdministratorLogin $Username `
    -AdministratorLoginPassword $Password `
    -StorageKeyType StorageAccessKey `
    -StorageUri $BackupDestination `
    -StorageKey $StorageKey `
    -StorageAccountResourceIdForPrivateLink "*******"


$exportstatus = Get-AzSqlDatabaseImportExportStatus -OperationStatusLink $export.OperationStatusLink
while ($exportstatus.Status -eq "InProgress") {
    Get-AzSqlDatabaseImportExportStatus -OperationStatusLink $export.OperationStatusLink
    $exportstatus = Get-AzSqlDatabaseImportExportStatus -OperationStatusLink $export.OperationStatusLink
    Start-Sleep -Seconds 15
}

这是我第一次看到这种错误

错误代码：

New-AzSqlDatabaseExport : An unexpected error occured while processing the request. Tracking ID: '************'
At line:25 char:9
+ $export=New-AzSqlDatabaseExport `
+         ~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [New-AzSqlDatabaseExport], CloudException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.ImportExport.Cmdlet.NewAzureSqlDatabaseExport
 
Get-AzSqlDatabaseImportExportStatus : Cannot bind argument to parameter 'OperationStatusLink' because it is null.
At line:40 char:74
+ ... seImportExportStatus -OperationStatusLink $export.OperationStatusLink
+                                               ~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (:) [Get-AzSqlDatabaseImportExportStatus], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,Microsoft.Azure.Commands.Sql.ImportExport.Cmdlet.GetAzureSqlDatabaseImportExportStatus

任何想法我必须改变什么。我几天来一直在努力解决这个问题，很难找到问题的答案。没有想法了:)

Answer 1

您可以通过增加目标数据库的大小来解决此问题。

您可以使用以下命令来增加目标数据库的大小。

-DatabaseMaxSizeBytes “DB_Size_in_bytes”