CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2005sql-server-2008
atricapilla
atricapilla

Reputation: 2630

How to operate with tempdb transaction log file?

I have a SQL Server 2005 instance and I got an error saying:

The transaction log for database 'tempdb' is full

Is it wise to shrink tempdb transaction log or give it more free space from the disk? How do you usually monitor or operate the transaction log of the tempdb?

Upvotes: 1

Views: 380

Answers (1)

Pavel Urbančík
Pavel Urbančík

Reputation: 1496

Preallocating based on expected usage and options (how much temp tables, sorting in tempdb on/off, rowversion based isolation level on/off, etc.) is fine.

Upvotes: 1

Related Questions