Failed to remote Backup


#1

Hi,

am trying to get remote backup of MSSQL server.
AM getting below error.

Failed to backup XXXX database with “Full” backup type: The StoredProcedure ‘[dbo].[USP_]’ cannot be scripted as its data is not accessible. > Property TextHeader is not available for StoredProcedure ‘[dbo].[USP_]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.

If I connect run the utility on same server, then it is working.

Could you please help me.


#2

Hi Mandar,

To resolve the issue, could you please go at the “Microsoft SQL Server Remote Backup Options” and disable “User Defined Functions and Procedures”.

Sorry for the inconvenience.