question

pits avatar image
pits asked

temp db error

Hello, The tempdb is full and ldf is started growing very fast , due to this the disk is about to run out of space i run the sqldiag now what next? is there any other solution to control this? thank you
errortempdb
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Search on Google for "tempdb full" should point you to alot of solutions, or things to check.
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
If TempDB is filling then there must be a transaction running somewhere that is taking a long time to complete. Try using sp_who and sp_lock to see if this is the case. In an emergency scenario you could add files onto TempDB to allow the transaction to complete but this int the best way to resolve the issue. You should make sure the transaction causing the problem should be run and why it is taking so long.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Check also with - `DBCC OpenTran` -
1 Like 1 ·
alexsdba avatar image
alexsdba answered
You need to BACKUP LOG [yourDb] TO DISK = N'Backup\yourDb.trn' GO DBCC SHRINKFILE(yourdbldf_file, 1) and then figure out what's causing this
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Not for tempdb.
2 Likes 2 ·
Thank you Thomas i haven't had my coffee at the time of posting and thought it was a transaction log question :).
0 Likes 0 ·
@alexsdba - Oh, I know that problem! :-)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.