国产精品亚洲综合色拍,人人干人人爱,中文字幕专区在线亚洲,清纯唯美激情视频二区

首頁 服務(wù) 產(chǎn)品 文檔 關(guān)于

壓縮sqlserver數(shù)據(jù)日志文件

USE [master]
GO
ALTER DATABASE dbname SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE dbname SET RECOVERY SIMPLE
GO
USE dbname
GO
DBCC SHRINKFILE (N'dbname_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE dbname SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbname SET RECOVERY FULL
GO