Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to create a SQL Azure database. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

We have already created a SQL Azure Server, located in Microsoft's "East Asia", the data center in Hong Kong. Here we show how to create a new Database on top of the SQL Azure Server that has been created.

1. First of all, please log in to the Windows Azure management user interface and enter your account information

two。 Click "--> Select the created SQL Azure Server-- > then click the" create New Database "button

(note that the icon "create" indicates the creation of a new SQL Azure database.)

3. In the pop-up window, we will be prompted to "create a database". There are two Database versions of SQL Azure.

1) Web

-the database sizes are 1GB and 5GB.

2) Business

-the minimum database size is 10GB and the maximum is 150GB

Why does Microsoft limit the size of the database? This is because the database you create will automatically make triple backups. For example, 150GB's database will automatically generate a primary backup of 150GB and two secondary backups of each 150GB. The actual disk space occupied is 150 (source service) + 150 (primary backup) + 150 backup 2 (secondary backup) = 600GB! There is no limit to the size of the database, the cost of time and space to create a backup is huge.

We name the database newDB, select the version "Business" and set the size to 10GB, and then select OK

4. Finally, we can see the newDB we created in the user management interface.

The above is the editor for you to share how to create a SQL Azure database, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.