en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP 


 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read first, before you you use the blog! Maximize
מאי18

Written by: ronen ariely
18/05/2020 18:07 RssIcon

Today I came across a strange error message. Actually the message is "clear" but totally wrong and the fact that it raised on this sever was completely illogical. The message definitely made me lose heartbeat for a second.

When executing the powershell command Get-AzSqlDatabaseGeoBackup on one specific server, I am getting an error bellow:

Get-AzSqlDatabaseGeoBackup : 40647: Subscription 'xxxxxx-xxxx-xxxx-xxxx-xxxxxx' does not have the server 'my-server-name'.

lose heartbeat for a second... what happen to the server?!?

I tried to execute the command Get-AzSqlDatabase to check what the F happening and where are all the databases in that server. What do you know?!? all seems OK and all the databases exists and seems OK, so how come the server does not exists while the databases exists? I tried the direct command Get-AzSqlServer to get a list of the Azure Logical servers in the subscription and the server is there.

Wow... My blood pressure returned to normal, and my heartbeat continued... I have now time to think WTF happen and at this time my conclusion is: IT IS A BUG

More information

I tested this on 2 different accounts. First account I testes on 2 subscriptions and in the second account there is one subscription and it returns the same error.

In the first account in one subscription there are multiple databases and in the second account I create new logical server for the test and there are no database but this does not change the fact that the command should not return that the Subscription does not have the server while the server is there. It should return empty list instead of error.

Conclusions

Sry... I have non at this time. I publish this to get your insights, and to present the information as part of my report to Microsoft team.

If you have any idea then you are welcome to post it. I am waiting for insights from Microsoft team in the meantime and anything that I will get which is allowed to be published in public I will add here...