How to read database name from SQL Server .bak file? [closed]

Question

I have SampleDB.bak file. Is it possible to read Db Name within this .bak file without restoring?

Answer 1

Below query will give you the logical file(Data file and Log File) name of the backup.

RESTORE FILELISTONLY FROM DISK = 'D:\MyBackups\Backup.bak'

Fore more info on FILELISTONLY

Answer 2

You can use below TSQL query

RESTORE HEADERONLY FROM DISK='D:\Database\Northwind.bak'