Restoring a redgate encrypted backup on a different server

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restoring a redgate encrypted backup on a different server

Postby muralijv » Thu Apr 11, 2013 10: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
Murali
muralijv
 
Posts: 1
Joined: Thu Apr 11, 2013 10:29 am

Postby eddie davis » Thu Apr 11, 2013 12:01 pm

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests