Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.
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