Can I mount an SQL server database over 1TB with 2008 Standard? Or would I need the HPC version for that? I don't think I do but I just want to double check before I do this full installation.

link|improve this question
should be asked on serverfault.com – Matthieu Jul 30 '09 at 22:58
Hi Kevin, welcome to StackOverflow. Perhaps try this question on ServerFault.com You'll get a good answer there, for sure! – p.campbell Jul 30 '09 at 23:03
Oh I didn't even know that existed. Thanks! – Kevin Jul 31 '09 at 0:03
feedback

migrated from stackoverflow.com Aug 1 '09 at 3:04

This question came from our site for professional and enthusiast programmers.

1 Answer

You can use the standard edition.

For what you want to do, the only limitation is the edition of sql server, I think you can use any paid for edition. The Express (free) edition has a limitation of 4GB for database size.

As you can see, Windows itself has no limitation on file size (excluding the fact you need NTFS for large files)

See here for the comparison of the different editions of Windows server - http://www.microsoft.com/windowsserver2008/en/us/compare-specs.aspx

See here for the comparison of the different editions of SQL server - http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

link|improve this answer
feedback

Your Answer

 
or
required, but never shown