SQLServerクリーンアップログファイルのメソッド事例詳細

USE [master]
GO
ALTER DATABASE Name of database to clean SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE Name of database to be cleaned SET RECOVERY SIMPLE --simple mode
GO
USE the name of the database to be cleaned
GO
DBCC SHRINKFILE (N'database_log' , 2, TRUNCATEONLY) -- Set the compressed log size to 2M, you can specify it yourself
GO
USE [master]
GO
ALTER DATABASE Database name to be cleaned SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE Name of database to be cleaned SET RECOVERY FULL -- Restore to full mode
GO