Restoring

si_he

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

petey

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.