I got it to work:
RESTORE DATABASE MyDBStaging
FROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'
--WITH RECOVERY
WITH MOVE 'MyDBStaging' TO 'E:\MSSQL\Data\MyDBStaging.mdf',
MOVE 'MyDBStaging_log' TO 'E:\MSSQL\Log\MyDBStaging.ldf',
REPLACE
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/