删除原始Azure SQL Server之后，通过门户还原Azure SQL数据库LTR备份 [英] Restore Azure SQL Database LTR back-up via the Portal after deleting the original Azure SQL Server

问题描述

我找不到这个问题的直接答案，所以希望有人遇到这个问题。

I can't find a straight answer to this question so hoping someone here came across this.

由于LTR备份与订阅相关，因此应该有一个即使已删除托管数据库的原始SQL Server，也可以使用一种还原备份的方法。

As the LTR backups are tied to the subscription there should be a way to restore a backup even if the original SQL Server that hosted the database is deleted.

在删除SQL Server之后如何通过门户查看和还原备份？

How can these be viewed and restored via the Portal after the SQL Server is deleted?

或通过其他方式。

推荐答案

当前没有还原整个服务器的内置方法。删除（软删除）服务器后，应在定期运行的清除过程完全删除逻辑服务器之前尽快致电Azure支持。没有用于服务器删除的SLA。因此，越快获得Azure CSS越好。

Currently there isn't a built-in method to restore the entire server. When a server is deleted (soft deleted) then you should call Azure support as soon as possible before a purge process that runs periodically fully removes the logical server. There are no SLAs for server deletions. So the quicker you can get to Azure CSS, the better it is.

如果删除服务器，则无法从Azure提供的自动内置备份中还原。从页面：

If the server is deleted, there is no way to restore from automated built-in backups offered by Azure. Quoting from the page:

如果删除Azure SQL数据库服务器实例，则其所有数据库
也被删除，无法恢复。当前不存在恢复已删除服务器的
支持。

If you delete an Azure SQL Database server instance, all its databases are also deleted and cannot be recovered. There is currently no support for restoring a deleted server.

因此，一切都是按原样进行的。当用户删除逻辑服务器时，您正在要求删除服务器，这就是为什么键入服务器名称等的原因。CSS可以与工程一起使用，以找出最好的方法，但是没有服务级别除非灾难恢复（地理复制，同步，长期备份等）是部署策略的一部分，否则就不能保证。

So everything is AS-IS. When a user deletes a logical server, you were asking the server to be deleted which is why you typed in the server name, etc. etc. CSS can work with engineering to figure out what is possible at best but there are no service-level guarantees unless Disaster Recovery (Geo-replication, Synchronization, long-term backups, etc.) was part of the deployment strategy.

我目睹了一个开发人员可以工作的情况例如，哥斯达黎加的一家公司在星期四删除了其生产的Azure SQL逻辑服务器，而Azure支持在下周一恢复了。通常，Azure CSS提供7天的时间来恢复被意外删除的Azure SQL逻辑服务器。

I witnessed a case where a developer that works for a company in Costa Rica deleted their production Azure SQL logical server on a Thursday and Azure Support was able to recover on the next Monday. Usually Azure CSS gives a time frame of 7 days to recover an Azure SQL logical server that was accidentally deleted.

为避免将来发生这种情况，您可以使用资源锁可以防止使用Azure门户意外删除。

To avoid this in the future you can use "resource locks" which can protect against accidental deletion using Azure portal.

这篇关于删除原始Azure SQL Server之后，通过门户还原Azure SQL数据库LTR备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！