|
|
發表於 2021-4-11 23:37:15
|
查看: 1562 |
回復: 0
SQL 2000&2005
---------------------------------------------------------------
USE [資料庫名稱]
GO
DBCC SHRINKFILE(記錄檔邏輯名稱, 1)
BACKUP LOG [資料庫名稱] WITH TRUNCATE_ONLY
DBCC SHRINKFILE(記錄檔邏輯名稱, 1)
GO
-------------------------------------------------------------------------------------
SQL 2008
--------------------------------------------------------------------------------------
USE [資料庫名稱]
GO
ALTER DATABASE [資料庫名稱] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(記錄檔邏輯名稱, 1)
ALTER DATABASE [資料庫名稱] SET RECOVERY FULL WITH NO_WAIT
GO
|
|
