新SQLAzure数据库不在门户也不经由PowerShell命令visable [英] New SQLAzure databases are not visable in the portal nor via the powershell cmdlets

问题描述

上周，我创建通过PowerShell和ARM模板的V12 SqlAzure服务器上的8个数据库，它工作得很好。我们开始在SQL Management Studio来使用这些数据库，并建立了用户和表等，有一个在他们的一些数据，我们可以选择和更新预期。总之，他们的工作！

Last week I created 8 databases on a V12 SqlAzure server via powershell and ARM templates, it worked fine. We started to use these databases in SQL Management studio and have set up users and tables etc. There is some data in them and we can select and update as expected. In short they work!

但今天我想用蔚蓝色的PowerShell命令新AzureRmResourceLock 应用一些资源锁的数据库，但我发现，命令 GET-AzureRmResource |位置对象{$ _。的ResourceType -eqMicrosoft.Sql /服务器/数据库} 不回我要找的！数据库

But today I wanted to apply some resource locks to the databases using the azure powershell cmdlet New-AzureRmResourceLock but I'm finding that the command Get-AzureRmResource | Where-Object {$_.ResourceType -eq "Microsoft.Sql/servers/databases"} does not return the databases I'm looking for!

此外，我现在看在门户网站 https://portal.azure.com ，然后我看到了SQL服务器上市了，当我进入刀片我的SQL Server我看到的数据库。但如果我点击一个数据库，我导致未找到资源。还使用SQL数据库时，刀片我看不到任何列出的数据库。

Also I now look in the portal https://portal.azure.com and I see the SQL Servers listed, and when i enter the blade for my sql server I see the databases. But if I click on a DB I'm lead to a not found resource. Also when using the SQL Databases blade I don't see any of the databases listed.

顺便说一句，如果我登录到门户网站的经典 https://manage.windowsazure.com 我可以请参阅SQL Server和看到所有的数据库，并点击它们，配​​置它们。

As an aside if I log on to the classic portal https://manage.windowsazure.com I can see the sql server and see all the databases, and click on them and configure them.

我真的不希望有重新创建这些数据库，我们已经开始对它们进行设置与模式，用户和数据，但确实需要能够使用cmdlet来改变尤其是它们资源锁在其中加入

I don't really want to have to recreate all these databases as we have started to set them up with schemas, users and data but do need to be able to use the cmdlets to change them especially to add resource locks to them.

有没有人看？并可能我尝试怎么把他们带回来，这样我可以使用PowerShell来重新配置。

Has anyone see this before? and what could i try to bring them back so i can use powershell to configure them again.

推荐答案

我是在与微软的支持，上周的触摸和他们一起来看看。这是分辨率。

I was in touch with Microsoft support last week and they had a look. this is the resolution.

来源：Microsoft支持电子邮件

From: Microsoft support Email

我怀疑，我们的情况下，从发行认购陈旧派生缓存。
  总之，当变化做出认购缓存可以变得陈旧
  订阅内出现一段时间。在努力减少我们的
  问题的情况下，我从后台刷新订阅缓存。

I suspect that our case issue derives from stale subscription cache. In summary, subscription cache can become stale when changes made within a subscription occur over time. In an effort to mitigate our case issue, I have refreshed the subscription cache from the backend.

他们一看之后，将它的那一天整理出来，无论是门户网站，更重要的是在命令行中是固定的。

After they had a look it was sorted out that day, both the portal and more importantly the command line are fixed.

感谢所有

这篇关于新SQLAzure数据库不在门户也不经由PowerShell命令visable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！