Not able to restore SQL Database with PITR?

Last week when I tried to restore the SQL database with PITR I got the following error message in Azure Portal.

{
    "status": "Failed",
    "error": {
        "code": "InternalServerError",
        "message": "An unexpected error occured while processing the request. Tracking ID: '4a4802a9-812c-48f4-86a0-f9fc9d7ba146'"
    }
}

After this error message, I could not see that database in Azure portal however the database was in restoring state when I checked with SSMS, that’s so strange! Not any more details in logs or anywhere else!
I checked this a few times and that’s why you can see a few databases in Restoring state!

So, in the first step I checked if CDC is enabled for this database, for checking this use this following TSQL in SSMS.

Select name,is_cdc_enabled from sys.databases

So, as you can see in my case CDC is enabled, please be aware in Azure SQL Database is currently in preview!

What can we do to fix the issue and restore the database?

First step I need to change the database owner to my SQL account. The key point is in this case DB Owner must be your server admin! Please in the portal go to the server and check who is Server Admin?

Then open the SSMS and run the following command.

ALTER AUTHORIZATION ON DATABASE::[MyNewDB_AD] to [matt];

Then try to use PITR again as you can see, I was able to restore with PiTR, You should be alright!