sqb2mtf generates multiple files
Hi,
I use sqb2mtf.ext to convert a .sqb file to SQL Server native format. But I got multiple output file.
I tried to use the following restore command to restore from these generated output files, but get an error.
Can anyone explain it please?
I use sqb2mtf.ext to convert a .sqb file to SQL Server native format. But I got multiple output file.
C:\Users\e>"C:\Program Files (x86)\Red Gate\SQL Backup 6\sqb2mtf.exe" "C:\TEMP\full\20120204164325_full_AdventureWorks.sqb" "c:\temp\a.bak" SQL Backup to Microsoft Tape Format converter Version 6.2.0.134, (c) Red Gate Software Ltd 2004 - 2009 Progress 10% Progress 20% Progress 30% Progress 40% Progress 50% Progress 60% Progress 70% Progress 80% Progress 90% Progress 100% MTF file created. C:\Users\e> C:\Users\e>cd \temp C:\TEMP>dir Volume in drive C has no label. Volume Serial Number is 806C-8C14 Directory of C:\TEMP 02/19/2012 09:24 PM <DIR> . 02/19/2012 09:24 PM <DIR> .. 02/19/2012 09:24 PM 91,553,792 20120204164325_full_AdventureWorks_00.bak 02/19/2012 09:24 PM 84,606,976 20120204164325_full_AdventureWorks_01.bak 28 File(s) 423,292,566 bytes 5 Dir(s) 4,381,503,488 bytes free C:\TEMP>
I tried to use the following restore command to restore from these generated output files, but get an error.
RESTORE DATABASE [test] FROM DISK = 'C:\TEMP\20120204164325_full_AdventureWorks_00.bak', DISK = 'C:\TEMP\20120204164325_full_AdventureWorks_01.bak' with REPLACE, MOVE 'AdventureWorks_Data' TO 'c:\\a.data', MOVE 'AdventureWorks_Log' TO 'c:\\a.log';
Msg 3183, Level 16, State 2, Line 3
RESTORE detected an error on page (0:0) in database "test" as read from the backup set.
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
Can anyone explain it please?
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
In the context of SQL Backup backups, the above is also applicable. In addition, you can merge the backup data that would normally go into multiple files in a striped backup, into a single file. This is done using the THREADCOUNT parameter. In your case, you most likely performed the backup using the parameter THREADCOUNT = 2.
Thus, when you now convert the SQL Backup backup to a native SQL Server backup, SQL Backup splits the backup data from that single file into 2 files, as those are the files that SQL Server require.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8