Cacher is the code snippet organizer for pro developers

--      ==============================
--      T-SQL Restore Script
--      Author: GDurgha
--      CreateDateTime: 20090328
--      (c) 2009 Media Riot, LLC
--      =============================

RESTORE DATABASE MPGIncentive
FROM disk = '<PutResultantBackupFileNameHere>'
WITH
        MOVE 'Catalog_dat' TO 'd:\database\MSSQL\data\Catalog.mdf',
        MOVE 'Catalog_dat' TO 'd:\database\MSSQL\data\Catalog_log.ldf',
        REPLACE,
        STATS

RETURN