SQL数据库在服务器上仍然可用时消失了 [英] SQL Database Disappeared by Still Available on Server
问题描述
我通过azure门户在sql server实例上创建了四个新数据库。 几天后,其中两个数据库从azure门户中的SQL数据库刀片中消失。但是,它们仍然在可用资源下的Azure SQL Server
刀片下的门户中显示。 当我点击那个资源,我得到以下信息:"的找不到此资源,可能已删除
。" 尽管如此,当我连接到那个sql server实例时,我仍然可以看到数据库并与之交互,但仍然没有问题。
I created four new databases on a sql server instance through the azure portal. After a few days, two of those databases disappeared from the SQL Databases blade in the azure portal. However, they still showed up in the portal under the Azure SQL Server blade under available resources. When I click on that resource, I get the following message: "This resource was not found, it may have been deleted." With all that said, when I connect to that sql server instance, I can see and interact with the database there still without issue.
要添加更多上下文,我确实为本地数据库中的所有对象生成了一个脚本,并在azure sql数据库上运行它们来设置结构和一些示例数据。 我真的不知道它是如何发挥作用的,但我想我会在讨论问题之前给出
尽可能详细的信息。
To add a little more context, I did generate a script for all of the objects from a local database and run them on azure sql database to setup the structure and some sample data. I don't really know how that could play a role, but I figured I'd give as much detail as I could about what I was doing before I ran across the issue.
推荐答案
你好,
我之前看到过客户的Azure帐户尚未验证之前的行为。您的帐户是否经过验证?
如果您的帐户已经过验证,请联系Azure支持:
< span lang ="EN-US"style ="color:black; font-family:'Arial','sans-serif'; font-size:10pt"> https:// docs。 microsoft.com/en-us/azure/azure-supportability/how-to-create-azure-support-request
希望这会有所帮助。
问候,
Alberto Morillo
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于SQL数据库在服务器上仍然可用时消失了的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!