I have deleted a database and trying to create one with same name but get already exists error

Hi @3P Tiqri Shaamil Welcome to Microsoft Q&A thanks for posting your question.

I understand that you are getting an error when copying from database as A database with the same name already exists on this server' and you can see in the portal the database has been deleted.

I would suggest you can try renaming the database to a different name first and then changing it back to the original name after the import is done.

You can try importing from portal or PowerShell to import database: PowerShell: Import a BACPAC file to a new database in Azure SQL Database - Azure SQL Database | Microsoft Learn

New-AzSqlDatabaseImport (Az.Sql) | Microsoft Learn

If the above steps don't resolve the issue, you can try contacting Azure support for assistance. They can help you troubleshoot the issue.

Regards

Geetha

When you are creating the database as a copy of an existing database, create the database with a different name instead of using the old database name. Once you do that change the compute size and service tier of the newly created database to be the same as the old deleted database. After that you can change the name of the newly created database as the name of the deleted database using Transact-SQL ALTER DATABASE.

ALTER DATABASE [ORIGINAL-NAME] MODIFY NAME = [RENAMED-NAME]

It seems you posted the same question on StackOverflow. There I provided the same answer.