• Log file was empty. Shrink released little bit space but didnt help. Restarted the service but size didnt drop. Shrink also not worked after restart, just was not releasing any space. No error in shrink. No open transactions of row versioning snapshot isolation level or such. No big temp object inside Db. So what i did thanks to someone who suggested here:

    ALTER DATABASE [tempdb] MODIFY FILE (

    NAME = N'tempdev',

    SIZE = 2048 ); --2MB

    Wow....!. it worked. but not without sql service restart after that. If you need to fix it without service restart, then............ sorry 🙁 U need to try something else.