Restoring a redgate encrypted backup on a different server

Forum for users of Redgate's SQL Backup tool

Restoring a redgate encrypted backup on a different server

Postby muralijv » Thu Apr 11, 2013 9:33 am

Hi Guys,

We are planning to use RedGate product for our backup solution. Before we go head with the product, I wud like to know how do I restore a encrypted backup on a different server without REDGATE tools. From time to time we provide production ( sanitised) DB backups for various third parties. how can I ensure that they can restore these backups taken by REDGATE tool.

Thanks your help
Posts: 1
Joined: Thu Apr 11, 2013 9:29 am

Postby eddie davis » Thu Apr 11, 2013 11:01 am

Hi, thank you for your forum post.

In the situation where you need to restore a backup file created by SQL Backup onto a machine that does not have our software installed. Simply use the conversation tool available in your SQL Backup install folder. The tool is called SQBConverter.exe by default installed when you install the SQL Backup GUI in this path:
C:\\Program Files\\Red Gate\\SQL Backup 7 - 32-bit machine
C:\\Program Files (x86)\\Red Gate\\SQL Backup 7 - 64-bit machine

Or download the stand-alone conversion tool available on this web PAGE. Scroll down the page and locate the SQL Backup to MTF Convertor.

Run the tool, specify the path to the backup file you wish to convert, as the backup file is encrypted, enter the password and convert the backup. This process creates a *.bak file that you can then use native SQL Server restore tools to restore the file.

Please note, depending on the number of threads used to create the original sqb, the conversion process will create a *.bak file corresponding to each thread.

For example, a sqb file created using 3 threads will create 3 bak files.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests