Last Sunday, my support team received a backup from one of our customers and customer requested some activities for their backup. Once we saved the backup it was named testing backup. The problem was, we deployed lots of databases for different applications at this client and we did not know that which database backup is he referring to. First of all it is not a best practice to name a backup like this, it must be proper naming conversion. However if you come across situation like this, there is a workaround to find the details about the backup without restoring it. But how ?
Given below is the script that will give you the details about the backup without restoring it to any database.
--This script is compatible with SQL Server 2005 and above. USE master GO RESTORE FILELISTONLY FROM DISK = N'C:\data\Testing Backup.bak' GO
Reference : MSDN