var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Larg TempDB Log file
My SQL Server Tempdb log file looks to be very larg now...its taking up lot disk space...
How is that I can control the size of tempdb log files...?? What should i do save some disk space...!!!
You can use this code:
Backup Log Database_Name with Truncate_Only
DBCC Shrinkdatabase (DB_Name, Truncateonly)
Which free up the space and releases it back to the operating system.
You can create a alert for the tempdb and when it gets really big you can execute a job with the code above.
Just create a job with the code above to execute nightly.