log檔案過大

1. DBCC LOGINFO(DBName)  檢視該資料庫Log檔案，而status為2，代表無法truncate而reuse

2. SELECT * FROM sys.databases   檢視該資料庫Log狀態為 REPLICATION，代表Log正在複寫的狀態，但是檢視本機發行、本機訂閱並無資料

3. DBCC OPENTRAN(DBName)  檢視該資料庫發現有一複寫狀態，確認該資料庫並無複寫

4. sp_removedbreplication   移除複寫

5. dbcc loginfo  該log status為0，代表可truncate

6. 備份log > shrinkfile log

USE DBNAME GO
-- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE DBNAME SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (DBNAME_Log, 1) GO -- Reset the database recovery model. ALTER DATABASE DBNAME SET RECOVERY FULL
GO