Menu
I have a database on my SQL Server 2008 express.
I right clicked it and i see Size is at 2.74 MB, but Space Available shows as 0.72 MB
What does this mean? Does this mean if i use .72MB more it will fill up? Can i expand this and is this an issue?
My concern is that there is some limit placed on my database but I have no idea if this is an issue or not. Someone on a forum said it should automatically grow?
460
Space Available” is space in the database that has not been reserved for database objects. With our situation, if database objects take up all the unallocated space, data and log files will grow by “autogrowth” value (we can see these property under database, properties, Files tab) until database size reaches 10 GB.
To display data and log space information for a databaseIn Object Explorer, connect to an instance of SQL Server and then expand that instance. Expand Databases. Right-click a database, point to Reports, point to Standard Reports, and then select Disk Usage.
The space available is the difference between the space reserved and the space occupied.
If your database has 0.72 MB of free space, and the drive it's on has plenty of free space, then don't worry about it.
As long as there is sufficient space and you haven't disabled the database's ability to autogrow,then the database will grow the data file when it needs to.
96
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
