• 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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