See Books Online for details of the RESTORE command.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp?frame=true
Be aware that this may replace an existing database on your server if
one exists with the same name.