数据库还原报告成功，但未还原数据库。 [英] Database restore report success, but database is not restored.

问题描述

我有一个Azure Linux Web App服务（运行连接到Azure postgreSQL数据库的烧瓶应用程序。

我正在通过门户网站工作，我已经为Web应用程序配置了连接字符串，并且已经安排了包含数据库的定期备份（在数据库部分下，"包含在备份中"）。

我对数据库进行了更改（通过webapp），停止应用程序，然后尝试从更改之前恢复到备份。 

它警告我将完全覆盖Web应用程序和数据库。如果只有：（。

还原后报告成功和还原已完成（它还会自动启动Web应用程序）。一旦启动，我进去但数据库没有恢复。我在恢复之前所做的更改仍然存在。

我在多个场景中重复测试但仍然没有成功。有人可以建议我可能是错误的，或者这是一个已知问题？

谢谢！

解决方案

嗨马克，

你对自己的备份有很高的信心吗？尝试还原是在更改之前创建的副本，还是备份服务已经遍历并覆盖增量副本？我试图了解您从
还原的副本是否来自与App Service正在写备份文件的存储帐户不同。 

你有吗？时间戳或其他指示是您测试的一部分？如果您可以将截屏发布到此主题，那将会有所帮助。

谢谢，

Mike 

Hi,

I have an Azure Linux Web App service (running a flask app connected to an Azure postgreSQL db.

I am working via the portal, and I have configured the connection string for the web app and scheduled regular backups which include the database (under the Database section, "Include in backup" is checked.)

I make changes to the database (via the webapp), stop the app and then attempt a restore to a backup from before the changes. 

It warns me that the web app AND database will be completely overwritten. If only :(.

After the restore reports success and restore has completed (it also automatically starts the web app). Once started, I go in but the database is not restored. The changes I made before the restore are still there.

I have repeated the test in multiple scenarios and still no success. Could anyone advise what I could be doing wrong or if this is a known issue?

Thanks!

解决方案

Hi Mark,

Do you have a high level of confidence the backup you are attempting to restore from is a copy made before the changes, or has the backup service already rolled through and overwritten the incremental copies? I am trying to understand if the copy you are restoring from is sourced from a storage account separate from where the App Service is writing backup files to. 

Do you have a timestamp or other indication that is part of your test? If you can post a screen capture to this thread, that would be helpful.

Thank you,

Mike 

这篇关于数据库还原报告成功，但未还原数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！