SQL Logical Server not visible using Get-AzSqlDatabaseGeoBackup

Question

All,

I am working on designing BCDR plan and I am trying to access Geo-Backup using Get-AzSqlDatabaseGeoBackup. However, the command is unable to find the server but the server exists under the subscription it is complaining. Any insight on why this behaviour?

Error Msg:

Here is the screenshot from Server Properties Page:

Can someone please share some insight on where I am doing wrong?

Thank you!

Answer 1

Hello @PS !

As we can read :

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore

Geo-backups and disaster recovery

A geo-backup is created once per day to a paired data center. The RPO for a geo-restore is 24 hours. A geo-restore is always a data movement operation and the RTO will depend on the data size. Only the latest geo-backup is retained. You can restore the geo-backup to a server in any other region where dedicated SQL pool is supported. A geo-backup ensures you can restore data warehouse in case you cannot access the restore points in your primary region.

If you do not require geo-backups for your dedicated SQL pool, you can disable them and save on disaster recovery storage costs. To do so, refer to How to guide: Disable geo-backups for a dedicated SQL pool (formerly SQL DW). Note that if you disable geo-backups, you will not be able to recover your dedicated SQL pool to your paired Azure region if your primary Azure data center is unavailable.

So you have to wait and tomorrow you will see the BAckup there , with the comand or via the Portal!

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

Hello @PS !

There seems nothing wrong with the command

Does this works via Cloud Shell ?

Can you please verify the Proivder is registered

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards