Using sqb2mtf tp convert a multi file backup
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
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.