Re: increasing the size of tempdb

Dale E. Reed Jr. ( (no email) )
Fri, 11 Apr 1997 01:28:04 -0700

Josh Hillman wrote:
>
> Currently, my "tempdb" size is 2MB with 1.54 MB available to data. How do
> I increase this? When I double-click on the "tempdb" database and choose
> "Expand" I need to choose a "Data Device" and "Log Device" along with the
> sizes for each. What should I use for each of the above and what sizes?

Double click the master device. Add about 10 megs to the current size
of it
and save.

Then double click the tempdb and expand it 10 megs onto the master
device.

> Also, my "master" db is 17MB with 4.49MB available to data. Is this OK?

Its probably not going to cause any problems, but you may want to check
it
every once in a while. I don't like to let my databases get below about
5 megs
of free space.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com