sql server restore database
--Step 1: Check the logical file names with the help of the following command:
RESTORE FILELISTONLY
FROM DISK = 'E:\DBBackups\mydb.bak'
--Step 2: Use the logical names you get from the above query in the below query:
RESTORE DATABASE [mydb_new]
FILE = N'<MDFLogicalName>'
FROM DISK = N'E:\DBBackups\mydb.bak'
WITH FILE = 1
,NOUNLOAD
,STATS = 10
,MOVE N'<MDFLogicalname>' TO N'E:\DBBackups\mydb_new.mdf'
,MOVE N'<LDFLogicalName>' TO N'E:\DBBackups\mydb_new_0.ldf'