In this post, I am providing one T-SQL script which generates DBCC Shrinkfile for each database file of the SQL Server. You can also visit one of the related article: SQL Server: The TempDB is Full, Shrink it or Move it Generally, database administrator prefers to execute SHRINK when the database file is occupying more […]