Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shady_taah
Starting Member
2 Posts |
 Posted - 2009-01-06 : 10:28:41
|
| Hello, I am new to SQL, I have a database that is 1 TB in size and growing. I just want to know what is the mazimum recommended size for a sql database before it gets out of control.Thanks |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2009-01-06 : 10:46:01
|
| Hi,SQL Server can have database of size 524,272 terabytes that is the size is not limited.If you have enough disk space then database size is not an issue.RKNAIR |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-06 : 12:11:17
|
quote:
Originally posted by ratheeshknair
Hi,SQL Server can have database of size 524,272 terabytes that is the size is not limited.If you have enough disk space then database size is not an issue.RKNAIR
Processors,Memory,Faster disk systems and Edition of OS Play vital role for it. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-06 : 12:43:01
|
| You will run out of some other resource, like money, long before you run into a physical size limitation.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shady_taah
Starting Member
2 Posts |
Posted - 2009-01-06 : 15:34:05
|
| I am running SQL 2000. Is my limit still 542,272 Teras? |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
|
|
|
|
|
|
|
Maximum Database Size