How to list attached files included within LiteSpeed backup set?
1. Run the Restore Wizard.
2. The following queries, run in SSMS will provide the list of attached files:
exec master.dbo.xp_restore_headeronly @filename = '<path_to_the_backup>', @attachedfiles = 3
the script gives you the list of attached files only
if you pass:
@attachedfiles = 2 (instead of 3) you will see backup set information also.
Enhancement request CR 84921 has been submitted to Development for consideration in a future release of Litespeed for SQL Server.