Using sqb2mtf tp convert a multi file backup

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Using sqb2mtf tp convert a multi file backup

Postby john.waller@microlise.com » Mon Apr 14, 2014 4:05 pm

As part of our DR procedures we want to start to use the Redgate option option "Split backup into multiple files". This is to reduce the size of a single backup file to make things easier when we manually copy the backups to a 3rd location. As part of out testing I now need restore this backup onto a server which does not have redgate. I've used the sqb2mtf utility to convert the seperate files from .sqb to .bak, but when I try to restore the backup using the following command:

RESTORE DATABASE [Live_Reports] FROM DISK = N'F:\\MultiFile\\FULL_Live_Reports_20140414_081818_01.bak', DISK = N'F:\\MultiFile\\FULL_Live_Reports_20140414_081818_02.bak' WITH FILE = 1, MOVE N'Live_Reports' TO N'G:\\MSSQL\\SQL.DATA\\Live_Reports.mdf', MOVE N'Live_Reports_log' TO N'E:\\MSSQL.1\\LOGS\\Live_Reports.ldf', NOUNLOAD, STATS = 10
GO

I get the error:

Msg 3183, Level 16, State 1, Line 1
RESTORE detected an error on page (1:100919) in database "Live_Reports" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

The server I have tried this on does have Redgate installed and I can sucessfully restore the .sqb files using the Redgate GUI. I have tried to running sqb2mtf and restoring twice and get the same error both times but on different pages.

Can anybody confirm if they have sucessfully converted a multi file backup from .sqb to .bak and been able to restore it.
john.waller@microlise.com
 
Posts: 1
Joined: Mon Apr 14, 2014 3:16 pm
Location: Nottingham

Postby chriskelly » Wed Apr 16, 2014 11:17 am

Instead of first using the sqb2mtf utility, you might be better restoring all the .sqb files in a single script. To specify multiple files please refer to the section titled "FROM DISK argument" in this document. Don't forget that the script will need to invoke the SQL Backup extended stored procedure (as shown in the Examples is this document).

https://documentation.red-gate.com/disp ... RE+command
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests