Thanks it worked! So here we are not moving the file to different location.

That means we are just altering the file size with following command.

ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev, SIZE = 1024 ).

So this will resize after SQL Server restart? Please correct me if I am wrong?

Thanks