Creating a SQL Azure database
SQL Azure is a multi-tenanted database system in which many distinct databases are hosted on a single physical server managed by Microsoft. SQL Azure administrators have no control over the physical provisioning of a database to a particular physical server. Indeed, to maintain high-availability, a primary and two secondary copies of each SQL Azure database are stored on separate physical servers.
Consequently, SQL Azure does not provide a way for the administrator to specify the physical layout of a database and its logs when creating a SQL Azure database. The administrator merely has to provide a name and maximum size for the database. An administrator can create a SQL Azure database either on the Windows Azure Portal or by using the CREATE DATABASE Transact SQL statement.
SQL Azure supports two classes of database: web edition for small databases under 5 GB, and business edition for databases of 10 GB and larger. There is no difference in these editions other...
