What are the challenges you face when working across database platforms? Take the survey
Options

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.

Comments

  • Options
    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
Sign In or Register to comment.