Solved

What is the maximum size of database in sql server 2008 ?

Posted on 2011-03-05
5
718 Views
Last Modified: 2012-05-11
i want to know that What is the maximum size of database in sql server 2008 ? or  how can i find it using query or stored procedure ??
0
Comment
Question by:Parth48
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 35044309
if it is enterprise edition, the maximum size will be 4GB, and for the rest the maximum depends up on the available disk space
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 35044336

SQL Server 2008R2 supports up to 10 GB of data

For the commecrcial versions, there is no size limitation
0
 
LVL 48

Accepted Solution

by:
dbrunton earned 500 total points
ID: 35044596
Table Size query

http://www.devx.com/tips/Tip/43147

There are limits to the sizes depending on which version you have/get.

See http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx?pf=true for a listing of them.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35044706
>>if it is enterprise edition, the maximum size will be 4GB<<
I suspect you mean the Express Edition and not "Enterprise" and that applies only to SQL Server 2005.

>>SQL Server 2008R2 supports up to 10 GB of data<<
That depends on the Edition.  SQL Server 2008 R2 Express Edition supports up to 10GB, while all other Editions are limited by disk space.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35044725
>>or  how can i find it using query or stored procedure ??<<
I do not believe this information is available.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Gift cards are not a new concept - it's been around for a very long time.  Undoubtedly, over the past you have received such a card or purchased one for a friend or relative.  Are you aware that you've been feeding the machine?  If not, read on :)
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question