• 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/