Error: 9002, Severity: 17, State: 6 TempDB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Error: 9002, Severity: 17, State: 6 TempDB

Author

Topic

rsh
Starting Member

2 Posts

Posted - 2007-07-24 : 11:56:51

Hi All,

I am getting the following error on my application log:
Error: 9002, Severity: 17, State: 6
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.

TempDB: Data File
Space Allocated: 655 MB
Automatically grow file checked By 10%
Unrestricted file growth option selected

TempDB: Transactiong Log
Space Allocated: 24 MB
Automatically grow file checked By 10%
Unrestricted file growth option selected

I have 200 GB free space on the drive where SQL is installed and backed up. This error message showed around last afternoon and didnt repeat itself. What should I do? Is this something to be worried about? What are my options?

Thank you,
R

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-24 : 12:33:38

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Shrinking%20TEMPDB

scroll down to yellow selected text

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources