Re: database 'tempdb' is full: Error: 9002, Severity: 17, State: 6

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

ALTER DATABASE will work. You can find examples in BOL for how to size
tempdb. Whatever size and growth increment you set will be the size it gets
on reboot, btw. Preferentially you should never see an actual tempdb data
or log growth on a production server - size it right from the get go.
Autogrowth is for "holy sh-t" scenarios, NOT routine maintenance!! :-)


--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"db" <db@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85170286-2BD8-4E71-91A2-7CF4D6775A07@xxxxxxxxxxxxxxxx

How to set the default value of tempdb .mdf and .ldf size which does not
changes on reboot?
--
ontario, canada


"Andrew J. Kelly" wrote:

It probably needed to grow the log file at the time and couldn't do it
fast
enough. Once the connection was killed the used space in the log would
have
been freed up. Make sure you always have plenty of free space in the log
and data files.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"db" <db@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4ED9FE9C-93E0-456C-B8F0-63C718A2255B@xxxxxxxxxxxxxxxx
SQL server 2000 SP4

I am getting this error message in sql log:

The log file for database 'tempdb' is full. Back up the transaction log
for
the database to free up some log space .Error: 9002, Severity: 17,
State:
6
(Source: A particular spid.


Everything looks fine on the database side. Temp database is on simple
recovery mode and has free space in both .mdf and .ldf files.



Why did I have this message

--
ontario, canada




.

Relevant Pages

  • Re: Thank you very much...again
    ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | delete..etc permissions on tempdb. ... |>database which would avoid some of this. ...
    (microsoft.public.sqlserver.security)
  • RE: temp database transaction log fills up
    ... There is 21GB of free space on the drive, ... Current size of the database is 2.7 GB and log 1.7 GBand the server was ... > for TEMPDB to grow, but still it failed with TEMPDB full errors. ... > Thank you for using Microsoft newsgroups. ...
    (microsoft.public.sqlserver.server)
  • Re: Can I move tempdb?
    ... Tempdb file name changes take affect after SQL Server is restarted and are ... reference posted by details procedures for moving other database files. ... Model isn't used to determine database file locations. ...
    (microsoft.public.sqlserver.server)
  • How many logical volumes for large database?
    ... We are about to migrate a large database server onto new ... Logs, and TempDB. ... First, we had four available SCSI channels, so by creating four arrays each ... course TempDB grows and shrinks as needed. ...
    (microsoft.public.sqlserver.server)
  • Re: The log file for database tempdb is full
    ... What would that query have to do with the tempdb ... which are automatically created in the tempdb database. ... Luckyly it is a test server so I have just ...
    (microsoft.public.sqlserver.server)