here's a script i've used for quite a while...
------------------------
USE master
go
ALTER DATABASE yourdatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE yourdatabase
FROM DISK = 'c:\path\filename'
with replace
ALTER DATABASE yourdatabase SET MULTI_USER
go
------------------------
I generally run...