SQL Server TempDB Issues |Temdb got filled 100% | Not able to shrink tempdb files

SQLSERVER版本高于2008以下示例将AdventureWorks2022数据库中的日志文件收缩到1MB。若要允许DBCCSHRINKFILE命令收缩文件，首先需要通过将数据库恢复模式设置为SIMPLE来截断该文件。。參考影片的文章的如下：

TSQL: DBCC SHRINKFILE Part I
TSQL: DBCC SHRINKFILE Part I
How to Shrink TempDB Database in SQL Server
How to Shrink TempDB Database in SQL Server
dbcc shrinkfile on log file not reducing size even after backup log to ...
dbcc shrinkfile on log file not reducing size even after backup log to ...
Shrinking Your MS SQL Server Transaction Log File
Shrinking Your MS SQL Server Transaction Log File
DBA Fundamentals: Maintenance: Shrinking Files
DBA Fundamentals: Maintenance: Shrinking Files
Best practices for shrinking files in SQL server
Best practices for shrinking files in SQL server
Best Practices for Shrinking a Large SQL Server Transaction Log File
Best Practices for Shrinking a Large SQL Server Transaction Log File
3. How Can I shrink My TempDB Without Restarting SQL Server?
3. How Can I shrink My TempDB Without Restarting SQL Server?
How to Shrink Data and Log Files | SQL Server | Database Design
How to Shrink Data and Log Files | SQL Server | Database Design
How to shrink a SQL Server transactional log file | Microsoft
How to shrink a SQL Server transactional log file | Microsoft

參考內容推薦

SQL SERVER

SQL SERVER版本高于 2008 以下示例将 AdventureWorks2022 数据库中的日志文件收缩到 1 MB。 若要允许 DBCC SHRINKFILE 命令收缩文件，首先需要通过将数据库恢复模式设置为 SIMPLE 来截断该文件。

dbccshrinkfile2008

SQLSERVER版本高于2008以下示例将AdventureWorks2022数据库中的日志文件收缩到1MB。若要允许DBCCSHRINKFILE命令收缩文件，首先需要通过将数据库恢复模式设置为SIMPLE来截断该文件。

參考資訊如下