Reducing Log File Size in MS SQL Server 2022 using the ...

Right-clickthedatabaseandselectTasks->Shrink->Files.ChangethetypetoLog.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,ThisarticledescribeshowtoshrinkadataorlogfileinSQLServerbyusingSQLServerManagementStudioorTransact-SQL.,您可以使用DBCCSHR...。參考影片的文章的如下：

How to find the SQL Server ErrorLog
How to find the SQL Server ErrorLog
How to Shrink Data and Log Files | SQL Server | Database Design
How to Shrink Data and Log Files | SQL Server | Database Design
Best practices for shrinking files in SQL server
Best practices for shrinking files in SQL server
TSQL: DBCC SHRINKFILE Part I
TSQL: DBCC SHRINKFILE Part I
SQL Server Transaction Log Not Shrinking
SQL Server Transaction Log Not Shrinking
Understanding and Optimizing the SQL Server Error Logs
Understanding and Optimizing the SQL Server Error Logs
SQL Server Log File is HUGE!
SQL Server Log File is HUGE!
Shrink Sql Server Log files on Production Databases
Shrink Sql Server Log files on Production Databases
DBA Fundamentals: Maintenance: Shrinking Files
DBA Fundamentals: Maintenance: Shrinking Files
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 ...

參考內容推薦

Truncate and shrink log files in SQL Server

Right-click the database and select Tasks -> Shrink -> Files. Change the type to Log . Under Shrink action, select Release unused space and click OK.

Shrink a File - SQL Server

This article describes how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL.

DBCC 收縮檔案（Transact-SQL） - SQL Server

您可以使用 DBCC SHRINKFILE <target_size> 縮減空白檔案的預設大小。 例如，如果建立5 MB 的檔案，然後再將檔案縮減為3 MB 且檔案仍維持空白，則預設的檔案 ...

SQL Server LDF 容量大爆炸(SQL Server ldf truncate & shrink)

Shrink Log file 縮小交易紀錄檔​ 多數時候資料庫管理者以及系統管理者，真正想要解決的是縮小交易紀錄檔，也就是令交易紀錄檔在檔案系統中所佔用的大小減少 ...

How to shrink a log file without backuping first?

You can temporarily set recovery model to simple and truncate log. You also need to find the long running transaction that is active and find the root cause.

Shrink Microsoft SQL Server Transaction Log Safely and Effectively

Right-click the database with Transaction Log that must shrink. Select Tasks > Shrink > Files. Click to shrink files. The interface that comes up gives options ...

How to Shrink a Microsoft SQL Server Database Transaction Log File

MS SQL Server Database Log files can grow large causing your database to go offline and be unavailable if the Transaction Log drive location ...

How to shrink the transaction log in SQL Server

On the Shrink File window, change the File Type to Log. You can also choose to either release unused space, reorganize pages before releasing ...

Microsoft SQL Admins: How can I reduce the size of my logs?

Database > Tasks > Shrink > Log files (I usually only show about 250MB of available shrink space anyway). Set database recovery type from Full ...

How to shrink the transaction log file in SQL Server

Expand Databases and then right-click the database that you want to shrink. Point to Tasks, point to Shrink and then click Files. Select the ...

mssqlshrinklogfile

Right-clickthedatabaseandselectTasks->Shrink->Files.ChangethetypetoLog.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,ThisarticledescribeshowtoshrinkadataorlogfileinSQLServerbyusingSQLServerManagementStudioorTransact-SQL.,您可以使用DBCCSHRINKFILE縮減空白檔案的預設大小。例如，如果建立5MB的檔案，然後再將檔案縮減為3MB且檔案仍維持空白，則預設的檔案 ...,ShrinkLogfile...

參考資訊如下