Shrinking database and database files in SQL DBA

Shrinking databases and database files in SQL Server DBA:

• The size of database is reduced by collectively shrinking the database files,releasing unused space.
• TO shrink individual database files.
• We can shrink tempdb. But shrinking files regularly is not a recommended practice, because these files may probably grow again. Also shrink operations causes’ data fragmentation.

We have some limitations on shrinking tempdb:

• Shrink operations do not shrink the version store or internal objects.
• In some cases the DBA might need to restart the server in a single user mode to allow shrinking of the tempdb.