英文:
azure making an extra database when i create one
问题
当我尝试在Azure上创建在线托管的数据库时,它会自动创建第二个。
我已经删除了整个资源,尝试再次创建数据库。一开始我以为是我的错误,尝试创建单个数据库,但仍然出现相同的问题。
英文:
when i try to make an database online hosted on azure it will automatically create a second one
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.
答案1
得分: 1
我尝试了相同的操作,但只部署了我创建的数据库。
但你获取的主数据库是一个系统数据库。
- 所有 SQL Server 系统级别的系统数据都存储在主数据库中。这包括适用于整个实例的元数据,如端点、相关服务器和系统配置设置。
- 因此,如果主数据库不可用,SQL Server 无法启动,也无法删除它。
请参阅此 MS 文档 以获取更多信息。
英文:
I tried the same and it only deploys the database which I created.
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论