
The following steps below is executed with the Microsoft SQL Server Management Studio.
Launch the SQL Server Management Studio. Expand the System Databases and right click on tempdb.

For shrink database, the size of a database is reduced by collectively shrinking the database files, releasing unused space.

For shrink file, the size of the database is reduced by shrinking individual files to release unallocated space.


