RESTORE FILELISTONLYFROM
DISK = ‘C:\DB.BAK
‘GO
RESTORE DATABASE DBLogicalName
FROM DISK = ‘C:\DB.BAK’WITH
MOVE ‘YourMDFLogicalName’TO ‘D:DataYourMDFFile.mdf’,
MOVE ‘YourLDFLogicalName’ TO ‘D:DataYourLDFFile.ldf’
got it from the following link :
http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/