SQL: Auto-Delete Azure SQL Database Servers with No Databases
In Azure SQL Database, a database server is a logical concept that’s used to keep details of connected databases. It does have a master database but it’s not like the on-premises equivalent.
It’s pretty much a container for logins. And it won’t let you create objects in it. I wish it would as there is occasionally code that I’d like to store at the server level. An example is code that I use to control scaling of databases from within T-SQL.
Can you have no databases?
Generally there is no point provisioning a server that has no databases. Servers aren’t charged separately, only the user databases are charged for. But you can create a server separately to creating databases attached to it.
So what happens to a server that has no databases?
If you have a server that hasn’t had any user databases within the last 90 days, it will be automatically deleted. It’s important to be aware that this can happen. The only thing that would be lost would be any pre-configured logins. You would need to recreate them when you later decide to provision a user database.
2026-05-22