Database Reference
In-Depth Information
•
By default data and log files are given the freedom to continue growing until the
disk is full; in other words, they have unrestricted access to disk space. In real-
world organizations, it is critical to manage the storage, so a size limitation is given
to a database.
Exploring Database Properties
After a database is created, sometimes you will want to know its properties such as its file name, path,
size, and so on. Follow these steps to explore the database properties:
1.
Right-click the newly created database MySqlDb in Object Explorer, and select
Properties.
2.
Go to the Files tab on the left side. You will see the settings that SQL Server
chooses on your behalf while executing the one-liner database creation
statement shown earlier. The Database Properties dialog will look Figure 3-6.
Figure 3-6.
Exploring database properties
