In MS-SQL Server there is a command restore labelonly, this returns a result set containing information about the backup media identified by the given backup device. Is there an equivalent LiteSpeed command?
The equivalent LiteSpeed command is xp_restore_headeronly.
This command is run from SQL Server Query Analyzer:
xp_restore headeronly can be used to retrieve all the backup header information for all LiteSpeed 2005 backups on a particular LiteSpeed 2005 backup device (disk or tape). The header information is sent as a row by the server for each backup on a given backup device in a table.
Example:
xp_restore_headeronly
@filename = 'd:\backup\Northwind200606280903LiteSpeed_Full.BKP'
xp_restore_headeronly
@filename='\\.\TAPE0'
