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