Introduction - If you have any usage issues, please Google them yourself
USE master
RESTORE DATABASE DB
FROM DISK = g:\back.Bak
WITH MOVE DBTest TO E:\Program Files\Microsoft SQL Server2005\Data\DB.mdf ,
MOVE DBTest_log TO E:\Program Files\Microsoft SQL Server2005\Data\DB_log.ldf ,
STATS = 10, REPLACE
GO