How To Find Last Backup Dates Of SQL Server Databases

 

With the help of the following script, you can find the date of the last backup of each database on that instance.

‘L’ indicates Log Backup. If you type ‘D’ in this section, you can see the last full backup date, if you type ‘G’, you can see the latest differential backup date.

If your database is included with AG, you can see the correct result when running this script on both nodes. Because the backup could be taken over the other node.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *