[Solved] Importing sqb into sql 2008 r2

[ck1402]

Little background
Have a client with one sever remote that was running a website and a sql server on it that was running sql 2008

They had a company do a backup of the server so we can move the server to better hardware on main site. The backup method they used was all enterprise manager. The ending product was an sqb file. Anything I have found on these files were from a program called redgate.

Anyways when trying to import the database in its claiming u know file and it will not import. Any suggestions?

 

[Mokester]

redgate supplies a command line tool...this can be used to convert the sqb file to sql backup file...once this is done, then perform the restore.

Get the tool here: http://downloads.red-gate.com/labs/sqb2mtf.zip

 

[ck1402]

Well apparently the SQL backup is a backu used by SQL enterprise manager. It does create a .sqb file.

Anyone have suggestions on importing that into SQL 2008 r2?

 

[ck1402]

Fix was simple. Has to issue the replace command instead of restore and it worked like a charm.