I don't remember if you have to stop/restart MSSQL service or not.
This will prevent your transaction logs from causing problems with running
out of space for your data.
Josh Hillman
hillman@talstar.com
----------
> From: Jeff Cummings <jcummings@foxinternet.net>
>
> I have a general question about SQL Transaction Logs.
>
> I'm attempting to do consolidation on about 850,000 call records and I
> continue to get good old error 1105, (transaction log) on my TEMPDB.
>
> 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