soutsjjw
9/3/2018 - 7:21 AM

SQL - 清除SQL Server Log檔

SQL - 清除SQL Server Log檔

CleanLog.sql
content_copyfile_download
USE [資料庫名稱]
GO
ALTER DATABASE [資料庫名稱] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(記錄檔邏輯名稱, 1)
ALTER DATABASE [資料庫名稱] SET RECOVERY FULL WITH NO_WAIT
GO