请解释SQL Azure“主”数据库 [英] Please explain SQL Azure "master" database
问题描述
SQL Azure中的主数据库是什么?我刚刚创建了一个订阅,一旦我创建了一个新的SQL Server,我马上得到主数据库1GB大小。
What's the "master" database in SQL Azure for? I just created a subscription and once I created a "new SQL Server" I immediately got "master" database with 1GB size. That database can't be deleted - "delete" button is not active in the management portal.
当我尝试部署一个.dbproj项目时,Visual Studio表示它无法部署到系统数据库。
When I tried to deploy a .dbproj project there Visual Studio said it "couldn't deploy to a system database".
我可以使用该数据库存储我的数据吗?我要创建一个新的数据库吗?
Can I use that database for storing my data? Do I create a new database instead?
推荐答案
master
系统数据库,负责保存有关服务器实例上的所有其他数据库的信息,系统度量/配置,管理登录和管理。数据库创建等,它的只读,不能删除。
master
is a required system database that's responsible for holding info about all the the other database on the server instance, system metrics/config, managing logins & database creation etc, its read-only and can't be removed.
您需要创建一个新的数据库并部署。
You will need to create a new database and deploy to that.
这篇关于请解释SQL Azure“主”数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!