BACKUP LOG DBName WITH NO_LOG; -- 2008 已移除
DUMP TRANSACTION DBName WITH NO_LOG;
USE [master]; GO
ALTER DATABASE DBName SET RECOVERY SIMPLE WITH NO_WAIT; GO
ALTER DATABASE DBName SET RECOVERY SIMPLE; GO
USE DBName; GO
DBCC SHRINKFILE (N'DBName_Log', 11, TRUNCATEONLY); GO -- 目標 11MB
USE [master]; GO
ALTER DATABASE DBName SET RECOVERY FULL WITH NO_WAIT; GO
ALTER DATABASE DBName SET RECOVERY FULL; GO
關鍵點:TRUNCATEONLY 僅釋放未使用空間不移動頁面,速度快且不碎片化;目標大小(11MB)視實際業務而定。
原因:使用 sa 登入附加,權限僅限 Data 目錄。
兩種解法: