Red Gate forums :: View topic - Using sqb2mtf tp convert a multi file backup
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Using sqb2mtf tp convert a multi file backup

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
john.waller@microlise.com



Joined: 14 Apr 2014
Posts: 1
Location: Nottingham

PostPosted: Mon Apr 14, 2014 4:05 pm    Post subject: Using sqb2mtf tp convert a multi file backup Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Wed Apr 16, 2014 11:17 am    Post subject: Reply with quote

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/display/SBU7/The+RESTORE+command
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group