What is the command to extract the contents of a SQL LiteSpeed backup file, without performing an actual RESTORE?
or Error:
"SQL Server has returned a failure message to LiteSpeed which has prevented the operation from succeeding.
The following message is not a LiteSpeed message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
Logical file 'Databasename_Data' is not part of database 'Databasename'. Use RESTORE FILELISTONLY to list the logical file names.
or Error:
Error 63201, Level 19, State 1, Line 0
"SQL Server has returned a failure message to LiteSpeed which has prevented the operation from succeeding.
The following message is not a LiteSpeed message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
Logical file 'Databasename_Log' is not part of database 'Databasename'. Use RESTORE FILELISTONLY to list the logical file names.
LiteSpeed command: EXEC master.dbo.xp_restore_filelistonly @filename='D:\Backup\2000\msdb_Full_200907122100.bak'
Native SQL Server command: RESTORE FILELISTONLY FROM DISK = 'D:\SQLBackup\Northwind.bak'
In SQL Server Query Analyzer, run the following command using LiteSpeed extended stored procedure:
EXEC master.dbo.xp_restore_filelistonly @filename='D:\SQLBackup\Northwind.bak'
The output will include:
FileNumber , LogicalName,PhysicalName, Type, FileGroupName, Size, MaxSize
Change the restore script so that the MOVE statement includes the correct location of the Logical Files.
