How to extract Sql Server native backup file from LiteSpeed backup.
- Posted by Sqltimes
- On March 20, 2014
- 0 Comments
Another quick one today:
A few days ago, there was a need to restore a LiteSpeed database backup file into our lab environment. Since we do not use LiteSpeed in our environment we were scrambling to figure out a way. Upon some light reading, it became apparent that there is a command line command to extract a native sql server backup file from this LiteSpeed backup file.
|
1
|
extractor.exe -F S:\MSSQL\Backups\PLAY\DBADB_LiteSpeed.bak -E S:\MSSQL\Backups\PLAY\DBADB_Native.bak |
The LiteSpeed backup file is about 50 GB, after extraction it created about 30 files with 4 GB each. So LiteSpeed compressed 120 GB file into less than 50 GB.
Using the RESTORE command below, we were able to restore this database.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
RESTORE DATABASE DBADB FROM DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak0' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak1' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak2' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak3' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak4' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak5' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak6' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak7' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak8' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak9' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak10' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak11' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak12' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak13' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak14' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak15' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak16' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak17' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak18' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak19' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak20' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak21' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak22' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak23' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak24' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak25' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak26' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak27' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak28' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak29' , DISK = N'S:\MSSQL\Backups\PLAY\DBADB_Native.bak30' WITH MOVE 'DBADB' TO 'H:\MSSQL\Data\MSSQLSERVER\DBADB.MDF' , MOVE 'DBADB_Data1' TO 'I:\MSSQL\Data\MSSQLSERVER\DBADB_Data1.NDF' , MOVE 'DBADB_Data2' TO 'I:\MSSQL\Data\MSSQLSERVER\DBADB_Data2.NDF' , MOVE 'DBADB_log' TO 'L:\MSSQL\Log\MSSQLSERVER\DBADB_log.LDF' GO |
Hope this helps,
_Sqltimes
0 Comments