SQLBackupAndFTP worked fine for months, we didn’t changed anything in this database.
But receive this error now:
ERROR: Failed to backup “xyz” database with “Full” backup type: The Table ‘[dbo].[ELMAH_Error]’ cannot be scripted as its data is not accessible. > Property Text is not available for DefaultConstraint ‘[DF_ELMAH_Error_ErrorId]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
Hi,
Please give us some time to check and fix this issue.
Sorry for the inconvenience.
To investigate this case we need more details. Could you please tell us are you able to generate scripts via SQL Server Management Studio?
Sure, we have tested it and generating scripts via SSMS is no problem at all.:
Hi,
Thanks for the details.
It seems this issue related to the permission settings. Could you please try to resolve this issue using the following suggestion: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/861d86c0-0bed-415f-85d0-5c02c8367918/property-text-is-not-available-for-defaultconstraint-this-property-nay-not-exist-for-this-object?forum=transactsql
Hi, great 
GRANT VIEW DEFINITION ON DATABASE :: OnlineServices TO “Backup”;
fixed it already. OnlineServices is out database name and Backup the login/user with datareader rights. Nevertheless I wonder why this occured out of nowwhere. We fill this database daily, but didn’t changed anything on the schema or the login/user. And have several other database, where the backups works fine with the same Login.
Thanks for your time & fast support
Hi,
Thanks for the details.
Yes, we have added some changes to scripting process and these improvements can affect your permission settings.
Sorry for the inconvenience.
