Re: increasing the size of tempdb

Jeffrey Betts ( (no email) )
Mon, 14 Apr 1997 11:41:40 -0700

Dale

I was following the bellow instuctions and when I tried to increase the
size of
the Master Database Device it says the size is -729 MB. When I check the
size
of the Master Database it says the data size is 17 Mb with Data Space
Available
of 4.56 MB. Can you please tell me what is wrong here

Thanks
Jeff Betts
Jbetts@ccaccess.net

----------
> From: Dale E. Reed Jr. <daler@iea.com>
> To: emerald@emerald.iea.com
> Subject: Re: increasing the size of tempdb
> Date: Friday, April 11, 1997 1:28 AM
>
> 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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com