I am trying to edit the SSIS Back Up Database Task And it gives the folowing error

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)

  • 1
    Was this SSIS package created by you? I looks like you do not have the proper permissions. Commented Feb 24, 2012 at 1:44

2 Answers 2


This is a known issue with SSIS designer (although I cannot find the Connect article at this time). Most likely the backup value key in the registry is not being updated correctly with the directory for this package.

To fix this (if you are on the default instance), launch Regedit and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer. Create a string value called "BackupDirectory" (no quotes) and in the value put the complete path of your backup directory. Then restart and your issue should be resolved.

For a named instance, the Regedit path is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\"name of your SQL instance"\MSSQLServer


I also got the same error while restoring a local copy of SQL Server database.To get rid of this error you need to create a string value and key field in the registry.Name the string field as BackupDirectory and in the value field write the path of the backup directory. You need to create this registry entry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server. For detailed information with screenshots refer this guide.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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