sql压缩备份

declare @SqlBackupDataBase as nvarchar(1000)
set @SqlBackupDataBase=N'BACKUP DATABASE 要备份的数据库名称 TO DISK = ''e:\目标位置\备份后的名称-'+
CONVERT(varchar(11),GETDATE(),112)+REPLACE(CONVERT(varchar(12),GETDATE(),108),':','')+'.bak'''
+'with STATS = 1,compression'

exec sp_executesql @SqlBackupDataBase