Search code examples
sqlazureazure-sql-database

azure making an extra database when i create one


when i try to make an database online hosted on azure it will automatically create a second one

before pressing showing hidden types

after pressing showing hidden types

i've deleted the whole resource and try to make an database again i thought it was my mistake at first and i tried to make single database but still the same problem.


Solution

  • I tried the same and it only deploys the database which I created.

    enter image description here

    but the master database you are getting is a system database.

    • All of a SQL Server system's system-level data is kept in the master database. This comprises metadata that is applicable to the entire instance, such as endpoints, related servers, and system configuration settings.
    • As a result, if the master database is unavailable, SQL Server cannot start and you cannot delete it.

    Refer this MS document for more information