RESTORE DATABASE Example. MS SQL is a pain, pain, pain. Hint: Use e.g. RESTORE FILELISTONLY FROM DISK='C:\MyData.bak' to get the necessary information.

Here the command from the cited blog entry:

ALTER DATABASE MyData SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE MyData FROM DISK = 'C\:BackupMyData.bak' WITH MOVE 'MyData_Data' TO 'C:\Data\datafile.mdf', MOVE 'MyData_Log' TO 'C:\Data\logfile.ldf', REPLACE