great support dale. thanks again.
Brad
> -----Original Message-----
> From: Brad Teague [SMTP:Teague@NetworksPlus.com]
> Sent: Monday, May 24, 1999 12:21 PM
> To: 'emerald@iea-software.com'
> Subject: RE: [Emerald] Need Help Fast - SQL Error Message
>
> When i double click "tempdb" and go to the edit database window. here's
> what
> i see:
> data size: 2 mb
> space available:
> log size: shared with data
> log space available : shared with data
>
> I'm not sure what that means. Should i create a data device just for
> tempdb?
> or what?
>
>
>
> > -----Original Message-----
> > From: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
> > Sent: Monday, May 24, 1999 12:11 PM
> > To: emerald@iea-software.com
> > Subject: Re: [Emerald] Need Help Fast - SQL Error Message
> >
> > Brad Teague wrote:
> > >
> > > I am getting this error message:
> > > "Error 1101: [SQL Server] Unable to allocate new page for database
> > 'tempdb'.
> > > There are no more pages available on valid allocation pages. Space can
> > be
> > > created by dropping objects, extending the database, or dumping the
> log
> > with
> > > no_log."
> > >
> > > I have received a somewhat similar message before when the emerald log
> > ran
> > > out of space (i think) and I had to increase its size so that I could
> > then
> > > truncate it. I did that this time and it didn't work. I am still
> > receiving
> > > this same message no matter what I have tried. The Emerald log shows
> > that it
> > > is empty ..shows that its full size is available.
> > >
> > > I'm just not sure what this message means and I need to figure it out
> > soon.
> > > Any help would be greatly appreciated.
> >
> > tempdb is a different database than Emerald. You need to expand it,
> > similar to how you expanded your Emerald DB.
> >
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com