Options

Restoring

si_hesi_he Posts: 25
edited June 21, 2007 1:09PM in SQL Backup Previous Versions
Stupid question but I'll ask anyway... :roll:

Is it possible to restore a backup done in SQL Backup v5 using the SQL native restore command on a server that does not have SQL Backup installed?

Many thanks
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You cannot restore a backup created using SQL Backup using the native T-SQL commands.

    You need to first convert the backup file to the native SQL Server backup format, then use the native T-SQL restore command to perform the restore.

    There is a command line utility (sqb2mtf.exe), that ships with SQL Backup, that can perform the conversion. There is also a GUI version, which you can download from here (http://www.red-gate.com/messageboard/viewtopic.php?t=4689). Both utilities can be distributed and used freely, and does not require a SQL Backup license to function.
    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.