I have SQL Server 2012 Local DB Installed, and am connecting to it via (localdb)\v11.0.

When trying to restore a backup file, I get:

TITLE: Microsoft SQL Server Management Studio

Property MasterDBPath is not available for Information 'Microsoft.SqlServer.Management.Smo.Information'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=MasterDBPath&LinkId=20476

I have tried setting MasterDBPath string value in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer\CurrentVersion`

but this hasn't helped.

Anyone have any thoughts?

  • What is the source SQL Server edition and version of the backup file? – Thomas Stringer Sep 4 '12 at 2:48
  • The backup is from a SQL Server 2012 Developer edition install. – Andy Neillans Sep 4 '12 at 7:51

I had the same problem, and solved it.

You need to add 2 strings in the Windows Registry via regedit.exe at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer:


For me, their values are both C:\Users\neil\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0.

| improve this answer | |
  • 1
    Thanks - this worked for me running as administrator however I did also have to create a third key BackupDirectory which I pointed to a similar directory. – DaveHogan Jul 6 '13 at 15:35

Not really a proper solution, but this error does not occur if you create a blank database, then restore your backup overwriting the blank database.

Or you can use the restore T-SQL commands:

    MOVE 'example_dat' TO 'C:\Temp\<database>.mdf',
    MOVE 'example_log' TO 'C:\Temp\<database>.ldf'
| improve this answer | |

The problem was fixed after I installed the newest Microsoft SQL Server Management Studio 2017.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.