Restoring a database in MS SqlServer without using the UI

restore.sql

-- Replace MYDB with the name of your db below

-- close existing connections
ALTER DATABASE MYDB
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO

-- switch to some other db
USE master

-- determine the mdf, log file names that may be present in the .bak file
RESTORE FILELISTONLY
FROM DISK = 'C:\path\to\MYDB.bak'
GO

-- perform the actual restore (mdf and ldf names will come from the step above)
RESTORE DATABASE MYDB
FROM DISK = 'C:\path\to\MYDB.bak'
WITH MOVE 'MYDBDat.mdf' TO N'C:\path\to\MYDBDat.mdf',
MOVE 'MYDBLog.ldf' TO N'C:\path\to\MYDBLog.ldf',
REPLACE
GO