DECLARE @dbname VARCHAR(60)
SELECT @dbname = CONVERT(VARCHAR(60), DB_NAME())
EXEC('DUMP TRANSACTION ['+@dbname+'] WITH NO_LOG')
DECLARE @logname VARCHAR(60)
SELECT @logname = name
FROM sys.sysfiles
WHERE name LIKE '%log'
EXEC('BACKUP LOG ['+@dbname+'] WITH NO_LOG')
EXEC ('DBCC SHRINKFILE(['+@logname+'],1)')
日志收缩
最新推荐文章于 2024-07-20 21:25:25 发布