Solved

DB Expansion

Posted on 1998-07-13
5
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

726 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