Options

SQL Backup file format / compatability with SQL Server

SamSam Posts: 7
edited June 1, 2006 8:32PM in SQL Backup Previous Versions
Is SQL Backup able to read & restore standard SQL Server 2000 backups created via Enterprise Manager?

Or does it have it's own proprietary format?

Also, the URL: http://www.red-gate.com/help/sqlbackup/sqlbackup.htm
Appears to get stuck in an endless redirect / reload loop when accessed with Firefox v1.5...
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    SQL Backup cannot restore native backup files created by SQL Server. The SQL Backup files are compressed and/or encrypted.

    You can always convert a SQL Backup file to the native SQL Server file format by using the provided sqb2mtf utility, and then use SQL Server to restore from the converted file. sqb2mtf can be freely distributed, so you can send it to users who do not have SQL Backup installed.

    You can also perform the conversion via the SQL Backup extended stored procedures, but you need to have installed SQL Backup in this case.

    Re the help pages, does this work ok (http://www.red-gate.com/help/sqlbackup/SQLBackup.htm#Topics/SBU_UsingSQLBackup.html) ?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    SamSam Posts: 7
    Ok, thanks.

    Might be a good idea to include a note in the help or feature pages regarding non-compatability with native backups for clarity
    · Share on Twitter
Sign In or Register to comment.