Not able to copy database with name which is deleted.

manish singh 10

We have deleted the database (ex "ABC_DB") and it is deleted successfully. now I am trying to copy a database with the same name ("ABC_DB") which we deleted but while coping it shows "A database with the same name already exists on this server."

Can you please help with this?

2 answers

Pratik Somaiya 4,206 Reputation points

2023-01-18T06:46:11.8033333+00:00

Hello manish singh

Azure gives you the opportunity to restore the deleted database back to the point it was deleted or any time within the retention period. The retention is determined by your service tier (7 days for basic, 35 for standard etc.)

Please check if the deleted database is visible in the portal under "deleted databases" tab under "Settings" on the logical SQL Server resource that hosted the database.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee

2023-01-18T06:50:49.6566667+00:00

Hi @manish singh ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand from the issue, you are unable to create a new SQL database with the same name as the one which is deleted by you on the same server.

I tried to reproduce the same scenario at my end and could see that on the server page initially I was also prompted that DB name already exists in the server:

Then I duplicated the browser tab and tried again it did not show the error and I could successfully create the DB:

The issue might be due to the browser cache taking previous value in the field. Please try in a different browser tab or in in-cognito mode.

Hope this helps. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Please sign in to rate this answer.
manish singh 10 Reputation points

2023-01-18T11:43:40.1933333+00:00

Thanks, You got my question correctly.
I follow the same using different browser tabs or in incognito mode, but did not solve my problem. even though I used a different machine as well but didn't get success.

ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee

2023-01-19T04:12:34.3166667+00:00

Hi @manish singh ,

Kindly check in your SQL server whether the Database you deleted earlier appears in the list of Deleted DB tab or it still appears under SQL Databases tab.

If this also does not help, I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks

manish singh 10 Reputation points

2023-01-19T04:47:42.0766667+00:00

It is showing in Deleted Database section.
Or even if I try to restore with the same name from deleted section it is not allowing me to do that, it is showing the same warning message.

ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee

2023-01-20T08:20:32.6466667+00:00

Hi @manish singh ,

This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks

Stefan Nyström 0 Reputation points

2023-01-25T08:23:47.19+00:00

Hi,
I just wanted to mention that I am experiencing the exact same issue today. I can't restore the deleted database using the same name, and I can't copy another database to replace the deleted database (using the same name).

Sébastien Hodgson 5 Reputation points

2023-01-25T12:45:47.3466667+00:00

Hello,
We're experiencing the same issue. That behavior was not there before as we were able to delete and copy a database with the same name as the one previously deleted without having to wait the retention period. This is part of our processes and we're stuck by that.

ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee

2023-01-27T06:18:02.7333333+00:00

Hi @Stefan Nyström, @Sébastien Hodgson ,

This is strange and not expected. I hope you have tried all above-mentioned troubleshooting steps like checking inside Deleted Databases tab and SQL Databases of the server, refreshing of the page, trying in in-Cognito etc.

If the above solutions do not work in your case, I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks

Sébastien Hodgson 5 Reputation points

2023-02-01T11:45:20.64+00:00

Hello @ShaktiSingh-MSFT , I indeed opened a ticket and was told that it was a real issue that they were investigating. Got the confirmation yesterday that the product team reverted some changes so now it should be working fine. As a workaround (while this was an issue), the direct Azure CLI to copy the database was still working

ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee

2023-02-01T11:49:39.4433333+00:00

Hi @Sébastien Hodgson ,

Thank you so much for sharing the solution with the community.

We appreciate your effort for the same and happy that you are able to proceed with the workaround.

Have a great day!
Sign in to comment

Share via

Not able to copy database with name which is deleted.

2 answers