压缩备份数据库

 

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