Solved

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

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Recursion 6 33
Windows 7 to Windows 10 and back. IE 9.0, 10.0, 11.0 10 63
return value based on substr 10 46
Access #Deleted data 20 39
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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 :)
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…

762 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