Red Gate forums :: View topic - SQL Backup to MTF Converter - new user interface available
Return to www.red-gate.com RSS Feed Available

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

SQL Backup to MTF Converter - new user interface available

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Wed May 16, 2007 10:04 am    Post subject: SQL Backup to MTF Converter - new user interface available Reply with quote

If you use the sqb2mft.exe command line utility to convert SQL Backup files into native SQL Server (MTF) backup files, then you may be interested to know that there is now a user interface.

See SQL Backup to MTF Converter on the Red Gate Labs
Back to top
View user's profile Send private message Send e-mail
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Tue Apr 01, 2008 4:19 pm    Post subject: Reply with quote

Hi,

does the sqb2mft.exe require SQL Backup to be installed to convert the sqb files or can i simply run this exe on my DR server and then use SSMS to restore the database if i have to handle an emergency?

thanks
Back to top
View user's profile Send private message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Tue Apr 01, 2008 4:43 pm    Post subject: Reply with quote

Yes, you can run this without a license and without SQL Backup being installed.
Yes, you can use it to convert the backup file to the native SQL Server format so you can then restore it using SSMS.
Back to top
View user's profile Send private message Send e-mail
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Wed Apr 02, 2008 10:00 am    Post subject: Brilliant Reply with quote

Thanks very much for that information. It means we can get on with recovery our databases without having to get tied up with SQL Backup installations and license transfers.

I have tried the exe and it has produced 3 .bak files for one .sqb file, is that because i used 3 threads in the backup job?

thanks again

Laughing
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Wed Apr 02, 2008 10:55 am    Post subject: Reply with quote

Hi,

I think so. SQL Server does not support multithreaded backups natively, it's a feature of SQL Backup. If you wanted to restore a multithreaded backup in SQL Server, you would need to specify all three files to the RESTORE command, for instance RESTORE DATABASE MyDb from disk='x.bak', disk='y.bak',disk='z.bak'...
Back to top
View user's profile Send private message
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Wed Apr 02, 2008 12:08 pm    Post subject: Reply with quote

Brian,

i got the restore to work from the multiple .bak files without any issues, i was just wondering why i got 3 and guessed it might be linked to the thread count used on the SQL Backup.

thanks
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Apr 04, 2008 2:40 am    Post subject: Reply with quote

Just to clarify, when you perform a backup using the THREADCOUNT option, the backup is internally performed using 'multiple DISK options' as done for native SQL Server backups, but instead of writing the output to multiple files, SQL Backup consolidates the data and writes it out to a single file.

That is why when you converted the SQL Backup file to native format, 3 files were generated as what is what SQL Server requires in order to perform the restore.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Melba2010



Joined: 28 Dec 2010
Posts: 1

PostPosted: Tue Dec 28, 2010 5:52 am    Post subject: Reply with quote

SQL backup programs allow you to write mirrored files and it will place the copies in multiple locations. While it might seem redundant to save things in more than one place, you won't feel that way if disaster hits and it effects your backup copies. So you know, it is possible for backups to become damaged or some won't work when you need them the most. This is why it is helpful to save files and databases in a variety of places.


esxibackups like that
Back to top
View user's profile Send private message
mySunSet



Joined: 23 Sep 2011
Posts: 2

PostPosted: Fri Sep 23, 2011 9:14 am    Post subject: Reply with quote

The SQL Server master database does not support log backups. Only full backups can be performed on the master database.
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