Hi,Everyone: I have a file with sqb extension(e.g: clark.sqb),how should i to restore database using the sqb file.thanks!
A:
Assuming someone just randomly chose that file extension for a standard SQL backup, you'd use it like this...
restore database MyDb from disk='C:\clark.sqb'
Scott Ivey
2009-05-14 02:54:59
+2
A:
I think that's a Red Gate SQLBackup file - have a look here for more information. You should be able to download a trial to try the restore.
Good luck!
Aaron Alton
2009-05-14 03:37:29
It is Red gate...
gbn
2009-05-14 04:17:23
A:
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"
Nick Sturgess
2010-10-15 01:09:51
* GUI interface: http://downloads.red-gate.com/labs/SQBConverterGUI.zip * Wiki: http://labs.red-gate.com/index.php/SQL_Backup_to_MTF_Converter
Nick Sturgess
2010-10-15 01:10:12