What is the maximum size MSSQL and MySQL can support?
Filed in SQL on Apr.01, 2009
What is the maximum size a Microsoft SQL Server database can be?
Microsoft SQL Server database size depends on which edition you use. Check the below table. I take MSSQL 2008 for reference:
| Edition | DB Size |
| Enterprise | Unlimited |
| Standard | Unlimited |
| Workgroup | Unlimited |
| Web | Unlimited |
| Developer | Unlimited |
| Express | 4 GB |
| Compact 3.5 | 4 GB |
Even though it says unlimited, be careful about the drive size 
What is the maximum size a MySQL Server database can be?
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Check if what size your folder supports.
This table gives you idea:
| Operating System | File-size Limit |
| Win32 w/ FAT/FAT32 | 2GB/4GB |
| Win32 w/ NTFS | 2TB (possibly larger) |
| Linux 2.2-Intel 32-bit | 2GB (LFS: 4GB) |
| Linux 2.4+ | (using ext3 file system) 4TB |
| Solaris 9/10 | 16TB |
| MacOS X w/ HFS+ | 2TB |
| NetWare w/NSS file system | 8TB |
Related posts:
Leave a Reply
You must be logged in to post a comment.