To restore a database backup with we can used the SQL command next:

CREATE DATABASE [dbname]; -- Create a database (If it was created is not necessary)
RESTORE DATABASE [dbname]
FROM DISK = ‘PATH_OF_THE_BACKUP’ -- Path of the backup file
WITH REPLACE,
MOVE ‘dbname_Data’ TO ‘DEST_PATH/dbname_Data.MDF’, -- File Path database or where we put
MOVE ‘dbname_Log’ TO ‘DEST_PATH/dbname_Log.LDF’ -- Same as above but for the log

This can be done from SQL Query Analyzer or any applications that do allow us to execute sentiencias SQL on database.

NOTE: Sorry for my english, but i am learning. I accept corrections.
(NOTE: was migrated of the old site)