Re: [Emerald] Need Help Fast - SQL Error Message
Dale E. Reed Jr. ( (no email) )
Mon, 24 May 1999 10:11:05 -0700
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