If you are using RedGate Sql backup to restore the database then you can use following t-sql code
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [AdventureWorks]
FROM
DISK = ''\\myserver\Backup\AdventureWorks_01.sqb'',
DISK = ''\\myserver\Backup\AdventureWorks_02.sqb''
WITH RECOVERY,
MOVE ''AdventureWorks'' TO ''H:\MSSQL\Data\AdventureWorks.mdf'',
MOVE ''AdventureWorks_log'' TO ''I:\MSSQL\Logs\AdventureWorks_log.ldf'',
REPLACE"'
