February 5, 2009 at 8:04 am
Do you now if there is a size limit to SQL server databases? For example, is there a limit to number of rows in a table or the size of data/log files? If there is, would there be a difference dependent on the version of SQL that you are using? I'm currently using 2000 but plan to move to 2005 soon.
February 5, 2009 at 8:13 am
That information is found in the Max Capacity section of the docs of each version of SQL Server.
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx
Database size 32bits 524,258 terabytes 64bits 524,258 terabytes
Kind regards,
Gift Peddie
February 5, 2009 at 11:31 am
The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.
February 5, 2009 at 11:41 am
Yes the change from 2000 to 2005 was a lot so I assumed it also changed in 2008 but the database size did not change.
Kind regards,
Gift Peddie
February 5, 2009 at 1:54 pm
Steve Jones - Editor (2/5/2009)
The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.
If anyone in the world has a 500 000 terabyte database I'd love to know about it, and know what they're storing it on.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply