מאי18

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

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...