Hi,



I've the following error message, which doesn't make sense to me.

The log file is not full, it has autogrow set to on and the disk drive on
which it

resides has 256GB free space. I hope i'm missing something and welcome

any suggestions on what to do or what to look at.



"Server: Msg 9002, Level 17, State 6, Line 1



The log file for database 'tempdb' is full. Back up the

transaction log for the database to free up some log space."

If the application is requesting space in TempDB and the request interval is
faster than the disk can allocate the space then you will see this message
whilst the Autogrow is happening.

If you have this much space then try pre allocating a larger TempDB



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Stressed" <k@c.co.uk> wrote

Just to add - check with Profiler what is going on. TempDb could be a target
of a DoS attack.

--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Thanks for that, it all makes sense now.



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

The server isn't exposed to the outside world, although the point has been
taken
on board for future occurences of the same.

Thanks.

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka (AT) avtenta (DOT) si> wrote in
message news:OPFEUOJlDHA.3024 (AT) tk2msftngp13 (DOT) phx.gbl...