• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 735
  • Last Modified:

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

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
Parth48
Asked:
Parth48
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
 
Ephraim WangoyaCommented:

SQL Server 2008R2 supports up to 10 GB of data

For the commecrcial versions, there is no size limitation
0
 
dbruntonCommented:
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
 
Anthony PerkinsCommented:
>>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
 
Anthony PerkinsCommented:
>>or  how can i find it using query or stored procedure ??<<
I do not believe this information is available.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now