shrinking tempdb log file

Question

shrinking tempdb log file

Dhruva_51

SSChampion

Points: 10521
More actions
June 3, 2013 at 7:12 am

#275897

Last week our tempdb log file grew in size and alerts started pouring in as we have just few space left on the drive. Now we have free space in the log file. Can I release the space to the OS ? If the file is used and if we issue a truncate command we will have consistency issues ........can we do it if free space is available?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Divine Flame SSCoach Points: 15943 More actions · Answer 1

muthyala_51 (6/3/2013)
Last week our tempdb log file grew in size and alerts started pouring in as we have just few space left on the drive. Now we have free space in the log file. Can I release the space to the OS ? If the file is used and if we issue a truncate command we will have consistency issues ........can we do it if free space is available?

If the process which filled the tempdb log file was one time only then you can shrink the tempdb log file to release the free space to OS.

However, if you are not sure that whether it can again increase to the same size because of the same process\query then there is no point in shrinking it. Rather, in this case you should move the tempdb log file to another disk with much space.

Sujeet Singh

e4d4 SSCertifiable Points: 5777 More actions · Answer 2

And shrink the tempdb while in use can cause inconsistency error in tempdb http://support.microsoft.com/kb/307487

Divine Flame SSCoach Points: 15943 More actions · Answer 3

e4d4 (6/3/2013)
And shrink the tempdb while in use can cause inconsistency error in tempdb http://support.microsoft.com/kb/307487

As per the URL given by you "This article discusses three methods that you can use to shrink the tempdb database to a size that is smaller than its last configured size" which I believe is not the case here.

However, I would recommend to do any shrinking of tempdb log file in the odd hours only.

Sujeet Singh

e4d4 SSCertifiable Points: 5777 More actions · Answer 4

Divine Flame (6/3/2013)
e4d4 (6/3/2013)
And shrink the tempdb while in use can cause inconsistency error in tempdb http://support.microsoft.com/kb/307487
As per the URL given by you "This article discusses three methods that you can use to shrink the tempdb database to a size that is smaller than its last configured size" which I believe is not the case here.
However, I would recommend to do any shrinking of tempdb log file in the odd hours only.

Yep, you're right