January 9, 2004 at 6:48 am
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?
January 9, 2004 at 6:55 am
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
January 9, 2004 at 7:03 am
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.
January 9, 2004 at 7:32 am
That's 1,048,516 Terabytes, not 1.05 Terabytes. For each database. Instances have no bearing on this limitation.
--Jonathan
January 9, 2004 at 7:36 am
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]
January 9, 2004 at 7:39 am
I thank both of you. You gave me exactly what I needed.
January 9, 2004 at 11:57 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply