• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

DB Expansion

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???
0
ppmb
Asked:
ppmb
  • 2
  • 2
1 Solution
 
odessaCommented:
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
0
 
ppmbAuthor Commented:
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?
0
 
ppmbAuthor Commented:
Adjusted points to 80
0
 
odessaCommented:
no you must type 0 to tell to the server that your TEMPDB is on your HD and after then to expand TEMP_DB device to 20
0
 
mativareCommented:
besides in MSSQL Server 7.0 beta space and memory allocation is automatic, no more this problem.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now