RESTORE DATABASE mydatabase
FROM DISK = '/path/to/mydatabase.bak'