Solved

DB Expansion

Posted on 1998-07-13
5
191 Views
Last Modified: 2010-03-19
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
Comment
Question by:ppmb
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:odessa
ID: 1091740
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
 

Author Comment

by:ppmb
ID: 1091741
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
 

Author Comment

by:ppmb
ID: 1091742
Adjusted points to 80
0
 
LVL 2

Accepted Solution

by:
odessa earned 80 total points
ID: 1091743
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
 
LVL 1

Expert Comment

by:mativare
ID: 1091744
besides in MSSQL Server 7.0 beta space and memory allocation is automatic, no more this problem.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
The AZure backup problem 11 51
find SQL job run average duration 24 53
SQL Server Trigger 8 33
add stored proc on publlication 4 16
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question