How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit?
Thanks
Al
Something like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al
|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment