SQl DB Size definition

I am new to SQL, using SQL Developer 2014.

I created a SQL database by importing tables from an existing Access DB.  Now I'm poking around to see what I can learn.  I clicked on the 'Files' group in the Database properties viewer.

In the 'Database' group there is and 'Size' entry with a value of 39853.50 MB
Directly underneath that entry is 'Space Available' with a value of .078MB.

Does that mean I am almost out of space?  One reason for going to SQL from our old Access DB was to be able to store much more data.

I will eventually need to store a lot more data in this SQL DB, probably up to 10 times what I have now.

Where is the size of the DB, or space allocated to the DB set in SQL?  In other DB's I've used a primary space was allocated with rollover size increments if the data outgrew the original definition.

In general how is the disk space allocation handled and managed in SQL?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

No it doesn't mean that you're running out of space.  That's the default DB size set during installation on your machine.

"Microsoft SQL Server 2008 Express edition has a database size limit to 4GB. Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB. Microsoft SQL Server 2012 Express edition has a database size limit to 10GB. Microsoft SQL Server 2014 Express edition has a database size limit to 10GB."

Scott PletcherSenior DBACommented:
The "space available" is out of the size already allocated from disk to that specific db.

If that db needs more space in the future, and you have enabled "Autogrowth", SQL will dynamically add more disk space to the db whenever it needs it, up to the max total size allowed (which defaults to "unlimited" for data files).  Be sure to specify "Autogrowth" as a fixed amount, such as 50MB, rather than 10% or some other %.  SQL performs better with a fixed amount and it's less risky.

Also, unless you have stringent security requirements, be sure to enable Instant FIle Initialization so that SQL doesn't have to pre-format data files.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlcktmguyAuthor Commented:
Is SQL Server 2014 Developer the same as 2014 Express Edition?  I thought the Developer edition di not have a size limitation.

Is there any way, or for that matter need to, change the allocation size from 4GB to something larger?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Deepak ChauhanSQL Server DBACommented:
No you are not out of space, SQL server automatically expand the data file whenever require.

Just make sure filegrowth is not set to restricted. It should be automatic and enough disk space should be available on disk.

@In general how is the disk space allocation handled and managed in SQL?

Here is very clear info:

@Where is the size of the DB, or space allocated to the DB set in SQL?

Current database size is 39853.50 MB and actual data size is SIZE- Available Space =actual.

On the same page (database property) , check the options given at left hand side, currently you are looking in General options, now click on FILES and check.
mlcktmguyAuthor Commented:
Sorry Scott I didn't see your answer before I responded.

Where do I set the 'Autogrowth' Property you mention?
Deepak ChauhanSQL Server DBACommented:
Right click on database > Property> Files
here you can see autogrowth settings and change it accordingly like 50MB or 100MB..
mlcktmguyAuthor Commented:
Excellent, thanks to all.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.