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

SQL Backup file format / compatability with SQL Server

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

Comments

2 comments

Sort by
  • petey
    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) ?
    petey
    0
  • Sam
    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
    Sam
    0

Add comment

Please sign in to leave a comment.