MS SQL Server – Quest – LiteSpeed – Database Restore Error

MS SQL Server – Quest – LiteSpeed – Database Restore Error

When one issues this query:

restore filelistonly
from disk = ‘E:\sales.bak’

The error message stated below appears:

Msg 3254, Level 16, State 0, Line 1
The volume on device ‘E:\sales.bak’ is empty.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

Msg 3254, Level 16, State 0, Line 1The volume on device ‘E:\sales.bak’ is empty.Msg 3013, Level 16, State 1, Line 1RESTORE FILELIST is terminating abnormally.

_________________________________________________________________________________________________________________________________

In this particular case, the error is traced back to the file that the Backup file was taken through Quest\LiteSpeed.

To correct install Quest LiteSpeed and use the corresponding Quest\LiteSpeed API

–read Quest\LiteSpeed backup file header
exec master.dbo.xp_restore_headeronly
@filename = ‘E:\sales.bak’

–read Quest\LiteSpeed backup file list
exec master.dbo.xp_restore_filelistonly
@filename = ‘E:\sales.bak’

EXEC master.dbo.xp_restore_database
@database=’SALES’
, @filename = ‘E:\sales.bak’
, @with = ‘MOVE “sales_Data” TO “E:\Microsoft\MSSQLServer\datafiles\Sales\sales_data.mdf” ‘
, @with = ‘MOVE “sales_Log” TO “E:\Microsoft\MSSQLServer\logfiles\Sales\sales_Log.ldf” ‘
, @with = ‘stats=1’