Parth48
asked on
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 ??
if it is enterprise edition, the maximum size will be 4GB, and for the rest the maximum depends up on the available disk space
SQL Server 2008R2 supports up to 10 GB of data
For the commecrcial versions, there is no size limitation
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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.
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.
>>or how can i find it using query or stored procedure ??<<
I do not believe this information is available.
I do not believe this information is available.