对数据库定期备份进行检查,并监控容量增长.可以用以下SQL查询并推送消息。
|
1 2 3 |
select database_name,name,backup_start_date,CAST(backup_size/(1024*1024*1024) AS DEC(28,2))AS [备份大小(GB)],CAST(compressed_backup_size /(1024*1024*1024) AS DEC(28,2)) AS [压缩后(GB)] from msdb..backupset where DATEDIFF(day,backup_start_date,GETDATE())=0 --当天的备份 |
© 2019, ITJOY.NET. 版权所有. 如未注明，均为原创，转载请注明出处。