I need to gather monthly statistics for my boss, on how many FULL backups were done in a month and which number Succeeded and which failed if any.
Is there a simple query that could give me this, based on SQL Server logs?
Thanks
backupsql serverstatistics
I need to gather monthly statistics for my boss, on how many FULL backups were done in a month and which number Succeeded and which failed if any.
Is there a simple query that could give me this, based on SQL Server logs?
Thanks
Best Answer
You might use below script to get history of backups in last 1 month:
Here
30
is a variable, which can be changed with any number up to which you want backup details however this would work only if you are not archiving backupset table in msdb database.Please refer below links for detailed info on these backup sets and what is backup fails:
https://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/
Query that displays backup information (successful and failed) SQL Server
Hope this helps.