i have DB Backfile in 

> 
> D:\Prabhagar\Projects\ZIP\Priya DB\Backups\Sample.bak
> 
> 
> 

When i restore it will restore to 

> 
> C:\Program Files\Microsoft SQL
>  Server\MSSQL11.SQLEXPRESS2012\MSSQL\DATA
> 
> 
> 

this directory. But i want to restore to 

> 
> D:\Prabhagar\Projects\ZIP\Priya DB\Backups\TestDB\
> 
> 
> 

How can i do?
i used the following query

> 
> RESTORE DATABASE backup\_lookup FROM DISK =
>  'D:\Prabhagar\Projects\ZIP\Priya DB\Backups\Sample.bak.'
> 
> 
> 

Please help me. thank you