restore DATABASE ABCD
from disk='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQL2008\MSSQL\Backup\20110701ABCD'
with
move 'ABCD' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQL2008\MSSQL\DATA\ABCD.mdf',
move 'ABCD_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQL2008\MSSQL\DATA\ABCD.ldf'
,NoRecovery
,Replace
go
