On SQL Server, TEMPDB is automatically incremented and depends on a disk size. If TEMPDB reaches the disk limit, you can increase the TEMPDB database size by adding
a datafile to another disk.
-
With the System Administration window open, click DBA > Add Datafiles.
-
Click the Temporary Database tab.
-
In the New file information section, type the datafile name, the datafile location, and the initial size (in MB).
-
Click Apply to add the datafile to the TEMPDB database.