Today i had very spesific case on temp db. My temp db has 10 datafile and all datafiles was full and database locked. I shrinked temp database, files and log files but it wasnt worked. Also i closed Sql server services and i opened again but still temp db sizes was full. Only when i changed initial sizes on each datafile to so small values then i solved problem. Someone can explain why after reboot my temp db didnt release space and never temp db was like this big size. It was always about of 60G. How i can trace why i had this problem ?
Hello All and Sean Lange and SQLmojoe,
I created job which is shrink temp db files 3 hours in a 1 time and problem solved. Thanks to everybody.