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

morrishrmorrishr Posts: 2
edited June 21, 2006 9:16PM in SQL Backup Previous Versions
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.
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    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"
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.