August 7, 2007 at 8:26 am
Hi not sure if I am in the right forum. I would like to know using TSQ how I can find what backups and logs have been performed in certain time scale. I would also like to have a few stats about them like length of time weather they where successful, or why they failed.
Any ideas ?
Thanks
Sorry about the title I can not edit it
August 7, 2007 at 8:22 pm
The msdb..backupset table contains most of the information you need. For file/tape information, link to the backupmediaset and backupmediafamily tables. Only details of successful backups are recorded in these tables.
As to the reasons for failure, you would need to look in the SQL Server logs and/or the Windows event logs. If using 3rd party backup tools, you would need to look at the log files generated by those tools.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply