?
Solved

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

Posted on 2011-03-05
5
Medium Priority
?
725 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 49

Accepted Solution

by:
dbrunton earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

771 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