MS-SQL Server - Restore Headeronly

Restore Headeronly

This option produces just the information about particular backup set.

Eg. 

- DeviceType (Disk/Tape/Virtual Device/Azure location)

- BackupType (Full/Log/Differential)

- Compression Info

- User and Server Name

- BackupStartDate

- BackupFinishDate etc.

https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-headeronly-transact-sql?view=sql-server-ver16

Additionally,

SQL CMD Run

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-run-transact-sql-script-files?view=sql-server-ver16

Best Regards

T. Amit Vaid S.