SQL Server 备份永久脚本

实现sqlserver自动备份， select @数据库文件大小=cast((convert (dec (15,2),sum(convert(bigint,case when status & 64 = 0 then size else 0 end))) + convert (dec (15,2),sum(convert(bigint,case when status & 64 <> 0 then size else 0 end)))) * 8192 / 1048576 as decimal(18,2)) from dbo.sysfiles