Saturday , September 23 2023

How To Find Backup Paths in SQL Server


Most companies have a backup strategy, maintenance procedures. In my article “SQL Server Maintenance“, you can find details about maintenance on sql server.

Therefore, the directory where the backups are located is usually known. However, in some cases, you can take backup except regular backup. In such a case, you can find the all backup’s paths of a database and backup times with the help of the following script.

The letter D in the section “type = ‘D'” means full backup. You can use the following letters to query other backup types.

The condition “is_copy_only = 1” in the script also means that the backup is copy_only. You can perform this query for all backups by removing this condition.

D Full Backup
I Differential Backup
L Log Backup
F File veya Filegroup Backup
G Differential File Backup
P Partial Backup
Q Differential partial Backup


About 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 *