Restore backup to another destination or server

MarkoEncinapy

How could I restore backup to another destination or server, I try for example.
try to do by T-SQL ( RESTORE DATABASE att2000SQL
FROM DISK = 'C:\DB.sqb';) but it gives me an error of:
The media family for device 'C:\DBxx.sqb' is not formed correctly. SQL Server cannot process it.
Msg 3013, Level 16, State 1, Line 1
Abnormal end of RESTORE DATABASE.

petey2

You first need to install the SQL Backup server components on the SQL Server instance you want to restore the database on.  

Next, you need to run the restore using the SQL Backup extended stored procedure e.g.

EXEC master..sqlbackup '-sql "RESTORE DATABASE att2000SQL FROM DISK = [c:\db.sqb]"'<br>

The command you ran failed because SQL Server does not recognize SQL Backup-created backup files.