Tuesday, July 9, 2013

How to convert LITESPEED backup file to SQL Server Native backup

Convert LITESPEED backup file to SQL Server Native backup

Copy Extractor.exe from the following path of LITESPEED Installed machine
%PROGRAM_FILES%\LiteSpeed\SQL Server

(OR)

Download and Install trail version of LITESPEED and copy Extractor.exe to target machine

1. Copy LITESPEED backup file to target server

2. Convert LITESPEED backup to SQL Server native backup using the below command

extractor.exe -F "Drive:\BackupFilename" -E "Drive:\BackupFilename_native.bak" -N 1

-F – Path of Litespeed backup file name
-E –Path to convert litespeed backup to native backup
-N – Number of files to extract from backup file

After extraction the backup native backup files will extracted to specified path

3. Restore native backup using the following syntax on source server

RESTORE DATABASE [OVM_Stg] FROM 
DISK = N'Drive\FileName_FULL_native.bak0',
DISK = N'Drive\FileName_FULL_native.bak1',
DISK = N'Drive\FileName_FULL_native.bak2',
DISK = N'Drive\FileName_FULL_native.bak3',
DISK = N'Drive\FileName_FULL_native.bak4',
DISK = N'Drive\FileName_FULL_native.bak5'
WITH  RECOVERY, 
MOVE N'Filename' TO N'C:\mdfs\dbname.Mdf', 
MOVE N'Filename_log' TO N'C:\Ldfs\dbname_log.ldf',
REPLACE,  STATS = 10
GO

 

No comments: