SQL Server 备份永久脚本

实现sqlserver自动备份，select@数据库文件大小=cast((convert(dec(15,2),sum(convert(bigint,casewhenstatus&64=0thensizeelse0end)))+convert(dec(15,2),sum(convert(bigint,casewhenstatus&640thensizeelse0end))))*8192/1048576asdecimal(18,2))fromdbo.sysfiles