SQL SERVER 清空LDF資料
-- 清空LDF資料
USE esminimalcom
GO
ALTER DATABASE esminimalcom SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(esminimalcom_log, 5)
ALTER DATABASE esminimalcom SET RECOVERY FULL WITH NO_WAIT
GO
2020-03-18
SQL SERVER 清空LDF資料
- 156
- 0
- SQL Server