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 |
|
vuacorona
Starting Member
8 Posts |
 Posted - 2010-07-22 : 12:08:17
|
| Dear friends,If my database is 300GB, then what is the maximum of tempdb can grow? Would that be 300GB or more?Thanksv. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-22 : 13:38:30
|
524,272 terabytes  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-22 : 14:49:54
|
Now now Russell, have you been playing with those pesky Cartesian joins again?  |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-22 : 14:54:57
|
| LOL.Ok, the answer is that it can grow to the size of the disks it lives on.The size it will grow to depends on usage.The maximum size a database can be is 524,272 terabytes. Probably your SANs are smaller than that. |
|
|
|
|
|
|
TempDB Maximum Size