How to restore SQL Server 2008 R2 backup on LocalDb 2012

Question

I have a database backup ( .bak ) created in SQL Server 2008 R2.

To test some features, for example, import this backup into LocalDB (2012). When I click the Restore button and select the database, the following error occurs:

The MasterDBLogPath property is not available for the information "Microsoft.SqlServer.Management.Smo.Information". This property may not exist for this object or may not be restored due to insufficient access rights. (Microsoft.SqlServer.Smo)

Answer 1

You need to add the following 3 registry keys (run / regedit):

 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer\DefaultData, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer\DefaultLog, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer\BackupDirectory 

With the name of an existing folder as the value (where you have write access), for example. "C: \ Databases".

Please read the excellent step-by-step instructions in the section http://www.roelvanlisdonk.nl/?p=2896 (from where I copied the answer).