摘要:[SQL]SQLSERVER2008 刪除交易記錄檔
ALTER DATABASE Northwind
SET RECOVERY SIMPLE
GO
ALTER DATABASE Northwind
SET RECOVERY FULL
GO先將復原模式切換成簡單模式就會刪除交易記錄囉
之後再切回FULL即可
2014-12-16
[SQL]SQLSERVER2008 刪除交易記錄檔
- 893
- 0