--查询日志名称
DECLARE @logName NVARCHAR(50);
SET @logName = (SELECT name FROM SYS.database_files WHERE type_desc='LOG' )
---------------------------------------------------------------------
USE [master]
GO
ALTER DATABASE '[数据库名称]' SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE '[数据库名称]' SET RECOVERY SIMPLE
GO
USE '[数据库名称]'
GO
DBCC SHRINKFILE (N'iTrade_MVC_log' , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE '[数据库名称]' SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE '[数据库名称]' SET RECOVERY FULL
GO
SQLSERVER 清理数据库日志
最新推荐文章于 2023-07-21 15:57:37 发布