从Portal恢复已删除的Azure SQL数据库 - 使用InternalServerError进行部署失败 [英] Restoring Deleted Azure SQL Database From Portal - Failing Deployment With InternalServerError

问题描述

我正在尝试在Azure中测试一些灾难恢复过程。



我在测试服务器上获取了一个生产Azure SQL数据库的副本，删除它，并尝试使用"已删除的数据库"恢复它SQL Server下的选项。恢复已删除的数据库备份时，它会在~34分钟后失败
，其中：

I am attempting to test some disaster recovery procedures in Azure.

I have taken a copy of a production Azure SQL database on a test server, deleted it, and am attempting to restore it using the "Deleted databases" option under the SQL Server. When restoring the deleted database backup, it fails after ~34 minutes with:

Status: Failed

代码：InternalServerError

Code: InternalServerError

消息：处理请求时发生意外错误。跟踪ID：'xxxxxxxxxx'

Message: An unexpected error occured while processing the request. Tracking ID: 'xxxxxxxxxx'

屏幕截图：

Screenshot:

我现在尝试了两次没有成功。这是令人担忧的，因为我不确定尝试在同一场景中恢复生产数据库时会出现同样的问题。

I have tried twice now without success. This is concerning since I am not sure this same issue would occur when trying to restore the production database in the same scenario.

我也尝试使用PowerShell执行恢复，但也失败了。

I have also tried performing the restore using PowerShell, but that failed as well.

PS C:\>$DeletedDatabase = Get-AzSqlDeletedDatabaseBackup -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"

PS C：\> Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $ DeletedDatabase.DeletionDate -ResourceGroupName $ DeletedDatabase.ResourceGroupName -ServerName $ DeletedDatabase.ServerName -TargetDatabaseName" RestoredDatabase" -ResourceId $ DeletedDatabase.ResourceID -Edition" Standard" -ServiceObjectiveName" S2" -PointInTime UTCDateTime

PS C:\> Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $DeletedDatabase.DeletionDate -ResourceGroupName $DeletedDatabase.ResourceGroupName -ServerName $DeletedDatabase.ServerName -TargetDatabaseName "RestoredDatabase" -ResourceId $DeletedDatabase.ResourceID -Edition "Standard" -ServiceObjectiveName "S2" -PointInTime UTCDateTime

Restore-AzSqlDatabase : Long running operation failed with status 'Failed'. Additional Info:'An unexpected error occured while processing the request. Tracking ID: 'xxxxxxxxxxxx''

行：1字符：1

+ Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $ Delet ...

+ Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $Delet ...

+〜 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo          ：CloseError：（:) [Restore-AzSqlDatabase]，CloudException

+ CategoryInfo          : CloseError: (:) [Restore-AzSqlDatabase], CloudException

+ FullyQualifiedErrorId：Microsoft.Azure.Commands.Sql.Backup.Cmdlet.RestoreAzureRmSqlDatabase

+ FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.Backup.Cmdlet.RestoreAzureRmSqlDatabase

可能导致此问题的原因是什么？我使用来自门户网站的Sample AdventureWorksLT源代码进行了相同的测试，它运行得很好，所以它似乎与我的应用程序的生产数据库有关。

What could be causing this problem? I did the same test using the Sample AdventureWorksLT source from the portal and it worked just fine, so it seems to be something with my application's production database specifically.

推荐答案

感谢您的反馈意见。此问题需要更深入的调查，并在此问题上立即提供帮助，如果您有支持计划，您可以提交支持服务单，否则您可以发送电子邮件至[e-mail]，并提供以下
的详细信息，我们希望在这件事上与你密切合作。 

主题网址：

订阅ID：

希望有所帮助。

这篇关于从Portal恢复已删除的Azure SQL数据库 - 使用InternalServerError进行部署失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！