Questions[azure-sql](server)

I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when restoring the bacpac file. I'm looking to avoid that and just restore the bacpac file over an existing (empty) database.

Ideally, the bacpac would be stored in a storage account container and I can reference the container and run a powershell command to perform the restore over my existing database. In my search I haven't found anything that'll accomplish this. Has anybody figured this out or something similar to what I described?

Thanks,

Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name.

The file is being pulled in from an Azure storage account. I was importing a bacpac file (575mb) of a database that's 16gb. I thought the database import had stalled and deleted the database that was created as part of the import. Since discovered that the import was still in flight.

Now when i try and create another import of the database with the same name.

I've tried running az sql db op list to list the job but as the database no longer exists it errors (i deleted it thinking it had failed but the jobs still there in the background).

Also tried the same via the Microsoft API - https://docs.microsoft.com/en-us/rest/api/sql/databaseoperations/cancel but that gives a 404 as the database isn't there.

Anyone any idea on how I can cancel the stuck job?

No support on the account at the moment so my idea of contacting MS has gone. Is there a timeout on the job?

Something went wrong, I can't connect to Azure SQL server. I try to remove it

but get an error:

Failed to delete the server: ***. ErrorCode: 504 ErrorMessage: {"error":{"code":"GatewayTimeout","message":"The gateway did not receive a response from 'Microsoft.Sql' within the specified

Nothing more info. Just I see in notifications, that infinite restoring process of database, included in this SQL Server.

How can I remove SQL server forcibly?

ADDED:

Deleting is being during 10 hours

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud.

Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just switch over to just using the new one. Instead of take it offline, create a bacpac file, upload it to azure storage, and restore from that one.

I want to do this to reduce downtime during the migration.

Azure doesn't support the traditional log-shipping, and This require that you are moving from a 2012 database or newer.

Edit: Made the question much clearer.

Created this a database from a backup.

I want to delete this database because I selected the incorrect backup. When trying to delete the database I get the following error:

Failed to delete the database: [DBNAME]. ErrorCode: 400 ErrorMessage: Cannot use reserved database name '[DBNAME]' in this operation. This is an SQL database.

Steps taken to delette database:

1. Open Azure Portal.
2. Select Database ([DBNAME]).
3. Click delete button.
4. Get above mentioned error.

Connecting with SSMS: The Database that I want to delete is not there