How can we help you today? How can we help you today?

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

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.
morrishr
0

Comments

1 comment

Sort by
  • 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"
    petey
    0

Add comment

Please sign in to leave a comment.