CODEWITHSUNDEEP
sql-server
Revan
Revan

Reputation: 1144

What is the maximum size of the database created in SQL Server 2008 R2? and Is it varies on Harddisk size?

CREATE DATABASE MYDB

USE MYDB

My question is what is the maximum size that can accommodate in the MYDB database .?

Upvotes: 0

Views: 122

Answers (4)

Amir Keshavarz
Amir Keshavarz

Reputation: 3108

In Sql Server Express edition maximum database size is 10 GB.

Upvotes: 0

PSK
PSK

Reputation: 17943

Maximum database size can be 524,272 terabytes in Enterprise edition. Note that a single data file can exceed 16 TB.

Upvotes: 0

Nagaraj S
Nagaraj S

Reputation: 13474

Database size maximum size is 524,272 terabytes

check here

http://msdn.microsoft.com/en-us/library/ms143432.aspx

http://weblogs.sqlteam.com/mladenp/archive/2007/07/24/60267.aspx

http://technet.microsoft.com/en-us/library/ms143432.aspx

Upvotes: 0

Adriaan Stander
Adriaan Stander

Reputation: 166356

Have a look at

Maximum Capacity Specifications for SQL Server

Database size:

524,272 terabytes

Upvotes: 2

Related Questions