Hi Bhupinder,
When restoring database to localdb/mssqllocaldb instance via SQL Server Management Studio GUI, as described in the blog, you need to choose 'Device' option, then choose the .bak file from your drive and restore the database.
Alternatively, you can restore database to localdb/mssqllocaldb instance by executing the following T-SQL scripts. Replace the paths with your own paths.
Restore Database MATERIALSDB From Disk = 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Backup\MATERIALSDB.bak'
With Move 'MATERIALSDB' To 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\MATERIALSDB.mdf',
Move 'MATERIALSDB_log' To 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\MATERIALSDB_log.LDF',
Replace,
Recovery;
Go
Thanks,
Lydia