Archive for the ‘LiteSpeed’ Category

How To Restore From Quest\LiteSpeed Backup Files?

Don’t be alarmed if you see the backup files in .FULL format. They will look something in the following fashion:

Z:\BigDB_1.FULL
Z:\BigDB_2.FULL
Z:\BigDB_3.FULL
Z:\BigDB_4.FULL

Most likely they are the backup files generated by Quest LiteSpeed.

You need to be aware that you can’t use the all familiar RESTORE FILELISTONLY command view the list of the database and log files contained in the backup set. You must use the LiteSpeed custom stored proc master.dbo.xp_restore_filelistonly to do the same. For example:

-- read Quest\LiteSpeed backup file list
exec master.dbo.xp_restore_filelistonly
@filename = 'Z:\BigDB_1.FULL'
,@filename = 'Z:\BigDB_2.FULL'
,@filename = 'Z:\BigDB_3.FULL'
,@filename = 'Z:\BigDB_4.FULL'

To restore the database, you can’t use the RESTORE DATABASE command to restore from the LiteSpeed backup files. You will need to use the master.dbo.xp_restore_database custom stored proc to perform your database restores from the LiteSpeed backup files. For example:

ALTER DATABASE BigDB
SET OFFLINE
WITH ROLLBACK IMMEDIATE
GO

EXEC master.dbo.xp_restore_database
  @database='BigDB'
 , @filename = 'Z:\BigDB_1.FULL'
 , @filename = 'Z:\BigDB_2.FULL'
 , @filename = 'Z:\BigDB_3.FULL'
 , @filename = 'Z:\BigDB_4.FULL' 
 , @with = 'MOVE "BigDB_Data" TO "D:\datafiles\BigDB\BigDB_data.mdf"'
 , @with = 'MOVE "BigDB_Log" TO "L:\logfiles\BigDB\BigDB_Log.ldf"'

Note the ” “s are embedded in the ‘s!