This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 51%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Hello,
I created a free Azure subscription, with a free SQL Database. The name was imposed MyFreeDB.
Then I took a S0 10 DTU subscription as an an upgrade of the SQL Database, on a free PAYASYOUGO subscription.
I tried to rename the SQL Database in SQL Server Management Studio, but then the database resource was no more available on Azure website, so I reverted to MyFreeDB. How can I rename this resource that is on the S0 plan without creating another one and take a new S0 plan?
Thanks,
Alain
An Azure relational database service.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Hi Heiwa Proje,
Greetings!
Rename an Azure SQL Database database
Use the following steps to rename an Azure SQL database using T-SQL in SQL Server Management Studio.
master database for your instance.MyTestDatabase database to MyTestDatabaseCopy.ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy;
Here are the steps to rename your database without creating a new one:
1.Ensure No Active Connections: Make sure there are no active connections to the database. You can use the Activity Monitor in SQL Server Management Studio (SSMS) to check and close any open connections.
2.Rename Using SSMS:
3.Refresh Azure Portal: After renaming, refresh the Azure portal to ensure the changes are reflected. Sometimes, it might take a few moments for the changes to propagate.
4.Check Database Properties: Verify the database properties in the Azure portal to ensure the database is still on the S0 plan.
I recommend you go through with the following doc for reference: https://learn.microsoft.com/en-us/sql/relational-databases/databases/rename-a-database?view=sql-server-ver16
I hope this information helps you find a more cost-effective solution for your Qlik Sense setup. Please do let us know if you have any further queries.
Hi Heiwa Projet,
You're very welcome! Just checking in to see if you had a chance to try the suggestions. Let me know how it goes or if you run into any issues, we are happy to help further.
Hi Heiwa Projet
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hi Heiwa Projet
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hello, sorry for the late response.
I was caught in the development and had not the time yet to try to rename the database. Your answer was great and I will comment as soon as I try to rename the database. Thans for your inquiry.
Alain
Answer accepted by question author
Hi,
Unfortunately, renaming resources in Azure is not allowed. The name is part of the resource ID of the resource which is unique across all resources in all tenants. Only option is to re-create the database. If you have data you will need to restore from backup the data.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.