SQL Server Maximum Size

Question

SQL Server Maximum Size

DarylAndDaryl

Default port

Points: 1491
More actions
January 9, 2004 at 6:48 am

#84345

Can any one tell me what, if any, the maximum database size for a SQL Server database is? Is there a maximum size for a SQL Server instance?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jonathan SSC-Insane Points: 20427 More actions · Answer 1

1,048,516TB for SQL Server 7 or SQL Server 2000, unless you're using MSDE where it's limited to 2GB. No difference when using instances.

--Jonathan

DarylAndDaryl Default port Points: 1491 More actions · Answer 2

Is 1.05TB for SQL Server instance or for a database? A SQL Server 2000 instance can have multiple databases and an NT server can have multiple instances.

Jonathan SSC-Insane Points: 20427 More actions · Answer 3

That's 1,048,516 Terabytes, not 1.05 Terabytes. For each database. Instances have no bearing on this limitation.

--Jonathan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Look at BOL for 'Maximum Capacity Specifications'

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

DarylAndDaryl Default port Points: 1491 More actions · Answer 5

I thank both of you. You gave me exactly what I needed.

Steve Jones - SSC Editor SSC Guru Points: 737757 More actions · Answer 6

http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp

SQL Server Maximum Size

Cookies on SQLServerCentral