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
Solved

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

Posted on 2011-03-05
5
713 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
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:ewangoya
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Undo Sprint PCS iPhone 7 Plus iOS upgrade 4 27
Software for Local History Museum Library 5 42
sql 2016 data tools breakdown.. 1 11
SQL Recursion 6 16
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
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…

808 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