This is sorta like "don't bite off more than you can chew". Emerald
2.2 and higher comes with the ability to specify a "chunk" of the
consolidation to do, rather than the whole thing. Trying to run a
consolidation on 850,000 records will typically require more space
than the size of your tempdb (the tempdb is used to sort/order the
results before giving them to Emerald). Use 2.2 and them work in
reverse order (highest number back, not the one in parenthesis) and
it should be fine.
> My question pertains to this:
>
> When I go into the TempDB and click Edit, it shows the Log as (shared with
> data)
>
> Do I need to specifically define a log file for the TempDB? I have a log
> device for my other databases, but I am unclear if TempDB uses the log
> device of the database, or does it require it's own.
>
> I have run all of the DBCC maintenance I can think of to correct the Log
> devices, and that worked great, but continue to receive Error 1105 on
> TEMPDB.
>
> Jeff
> _______________________
> Jeff Cummings
> Systems Analyst
> Fox Communications
> jcummings@foxinternet.net
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com