How to restore database using sqb files in SQL SERVER

Question

I have a file with sqb extension(e.g: clark.sqb),how should i to restore database using the sqb file.thanks!

Answer 1

SQB files are created using RedGate's SQL Backup Tool. They supply a command line tool called sqb2mtf that can be used to convert to a native SQL backup that can then be easily restored.

• CMD line tool: http://downloads.red-gate.com/labs/sqb2mtf.zip
• usage: sqb2mtf inputfile outputfile [password]
• e.g. sqb2mtf "d:\backups\pubs.sqb" "e:\data\pubs.bak"

Answer 2

SQB files are a SQL Server backup format created by Red Gate's SQL Backup Pro software.

As mentioned in Nick Sturgess' answer, there are command line and GUI tools available for converting SQB files into regular SQL Server backup files that can then be restored normally.

Additionally, if you have SQL Backup Pro's server components installed on your SQL Server, you can restore a database from SQB files directly using a stored procedure call like the following:

EXEC master..sqlbackup '-sql "RESTORE DATABASE [MyDatabase] FROM DISK = [C:\backups\*.sqb] LATEST_ALL WITH RECOVERY"' 

That command will restore the latest possible backup of the MyDatabase database from all of the SQB files in C:\backups\. So, if you have a handful of full backups, differential backups, and transactional backups all kept in C:\backups, this command will automatically calculate the latest backup that can be restored without you having to select the correct files manually and without having to convert the SQB files to another format.

There are a number of different options that can be used to restore your database from SQB files directly, including:

• Restoring to a database with a different name than that of the database in the backup
• Relocating where the MDF and LDF files should be stored (useful if the server you're restoring to is different from the server where the backup was taken)

All of these options (and more) are outlined on Red Gate's syntax example page.