USE [master] ALTER DATABASE [DB_Develop] SET RECOVERY SIMPLE WITH NO_WaiT ALTER DATABASE [DB_Develop] SET RECOVERY SIMP
USE [master]
ALTER DATABASE [DB_Develop]
SET RECOVERY SIMPLE WITH NO_WaiT
ALTER DATABASE [DB_Develop]
SET RECOVERY SIMPLE
Go
USE [DB_Develop]
DECLARE @logname VARCHAR(150)
SELECT @logname = NAME
FROM sys.database_files
WHERE NAME LIKE"%log"
DBCC SHRINKFILE(@logname, 11, TRUNCATEONLY)
GO
USE [master]
ALTER DATABASE [DB_Develop]
SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE [DB_Develop]
SET RECOVERY FULL
GO
使用时将DB_Develop更换为你需要操作的数据库名即可。
--结束END--
本文标题: SQL Server 数据库清空ldf日志文件
本文链接: https://www.lsjlt.com/news/3354.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0