-> I was trying to restore a database using SQL Server management studio. Right Click “Database” Folder -> Restore Database -> select “Device” -> Navigate the backup file and Click “OK”.
-> Received below error,
TITLE: Microsoft SQL Server Management Studio
Property BackupDirectory is not available for Settings ‘Microsoft.SqlServer.Management.Smo.Settings’. 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=14.0.17289.0+((SSMS_Rel_17_4).181117-0805)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=BackupDirectory&LinkId=20476
-> The error states that Property BackupDirectory is not available.
-> Right Click “SQL Server Instance” -> Click properties -> Database Settings -> Check “Database Default Locations”.
-> In my case “Backup: ” was empty,
-> Changed the default backup location to a valid path and tried the restore again. It worked fine this time!
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.
Worked like a charm. Thank you.
Glad it worked.