Dugi (4/29/2010)
GregoryF (4/29/2010)
Are you really sure it's 800TB and not 800GB?SQL 2008 only support 512TB Databases
http://msdn.microsoft.com/en-us/library/ms143432.aspx
So does SQL 2005
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx
No SQL Server supports over 512 TB, take a look more closely, the MAX spec. is 524272 TB (that's means in Peta Bytes)! So if the situation is true, it can be ! :w00t:
Thanks, I did not notice the factor of 100, I'm not used to files of such size...
But with a 16TB limit on datafiles, you would still need 50 datafiles. With a limit of 2TB on logs, 50 logs. That's an unrealistic number of drives with corresponding HBA cards. And both of those numbers assume that all files are at 100%.
The server that could process all of this, and the SAN that could store it, and the networking that can transfer it, would out of reach for all but the richest of companies.
If it's true, I'd love to play with it
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!