<div>
Temp DB expanding is from Server Configuration<br />
in Microsoft SQL Server Enterpriñå Manager:<br />
Server|SQL server ...| Configure ...<br />
Temp DB in RAM : 0 for stay on disk, x for memory allocation<br />
if 0 TEMP_DB device stands for expanding on disk<br />

</div>


Temp DB expanding is from Server Configuration
in Microsoft SQL Server Enterpriñå Manager:
Server|SQL server ...| Configure ...
Temp DB in RAM : 0 for stay on disk, x for memory allocation
if 0 TEMP_DB device stands for expanding on disk


<div>
Right now I have 2MB ( I think it's on HDD) and I would like to expand the tempdb to 20MB on disk. should I just type 20 in the box instead of 0 in the configuration tab?<br />

</div>


Right now I have 2MB ( I think it's on HDD) and I would like to expand the tempdb to 20MB on disk. should I just type 20 in the box instead of 0 in the configuration tab?


<div>
Adjusted points to 80<br />

</div>


<div>
besides in MSSQL Server 7.0 beta space and memory allocation is automatic, no more this problem.<br />

</div>


besides in MSSQL Server 7.0 beta space and memory allocation is automatic, no more this problem.


<div>
<div class="content wysiwyg-content">
How can I expand the tempdb thru a proper way?? I have been trying to expand the tempdb database inside the SQL server but all I got was error messages saying names are wrong or something like that! Which device should the tempdb should map to???
</div>
</div>


How can I expand the tempdb thru a proper way?? I have been trying to expand the tempdb database inside the SQL server but all I got was error messages saying names are wrong or something like that! Which device should the tempdb should map to???

DB Expansion

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.