SQL server 日志文件收缩 与日志文件备份

DECLARE @strbackup NVARCHAR(100)
 --改为日期加时间的
 SET @strbackup = ‘F:\bak\Test_bak_log_‘
     + REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120), ‘-‘, ‘‘), ‘ ‘,
                      ‘‘), ‘:‘, ‘‘) + ‘.bak‘
 BACKUP LOG MainTest TO DISK = @strbackup WITH INIT;
 GO

dbcc sqlperf(logspace)

use  DatabaseXX
DBCC LOGINFO;

USE [master]
GO

ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE WITH NO_WAIT
GO

ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE
GO

USE 数据库名称
GO

declare @dbName nvarchar(100)

set @dbName = (SLEECT name FROM sys.database_files WHERE type=1)
GO

DBCC SHRINKFILE(@dbName,1,TRUNCATEONLY)
GO

USE [master]
GO

ALTER DATABASE 数据库名称 SET RECOVERY FULL WITH NO_WAIT
GO

ALTER DATABASE 数据库名称 SET RECOVERY FULL