Restore Database [Database Name]

from Disk='[backup location]'

with move '[logical data file name]' to '[path to store mdf file]',

move '[logical log file name]' to '[path to store ldf file]'

to find out the logical name of data and log file you can use

Restore filelistonly from disk='[backup location]'

Eg.

Restore Database Test

from Disk='D:\backup\test.bak'

with move 'Test_dat' to 'D:\Data\Test.mdf',

move 'Test_log' to 'D:\Data\Test_1.ldf'

Regards

Shafat Husain