Need to recover a red-gate SQL backup file to another server

morrishr

I need to recover a red-gate SQL backup file to another server. The other server has an expired trial version of RED GATE SQL BACKUP on it. How do I recover the backup. Can I uncompress the REDGATE backup into a native SQL Server format and the guy that installed all the SQL BACKUP's is on vacation.

petey

If you are converting on the server where SQL Backup is installed, you can use the CONVERT command e.g.

EXEC master..sqlbackup '-sql "CONVERT ''e:\pubs.sqb'' TO ''e:\pubs.bak'' " '

If you have already copied the SQL Backup file to the other server, you can use the sqb2mtf utility found in the SQL Backup installation folder, to convert the file to native SQL Server format e.g.

sqb2mtf "e:\pubs.sqb" "e:\pubs.bak"