压缩备份数据库

DECLARE @SqlBackupDataBase AS NVARCHAR(1000)
SET @SqlBackupDataBase=N‘BACKUP DATABASE TableName TO DISK =‘‘D:\sql语句\TableName‘+CONVERT(varchar(11),GETDATE(),112)+REPLACE(CONVERT(varchar(12),GETDATE(),108),‘:‘,‘‘)+‘.bak‘‘‘+‘with stats = 1,compression‘
EXEC sp_executesql @SqlBackupDataBase

压缩备份数据库

原文：https://www.cnblogs.com/tron001/p/11934816.html