清除数据库日志

USE [master]
GO
ALTER DATABASE Fuliu_Test SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE Fuliu_Test SET RECOVERY SIMPLE
GO
USE Fuliu_Test
GO
DBCC SHRINKFILE (N'Fuliu_Test_Log' , 0, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE Fuliu_Test SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE Fuliu_Test SET RECOVERY FULL

posted on 2016-10-07 15:31  不悔的青春  阅读(126)  评论(0编辑  收藏  举报

导航