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
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: