Error while invoking backup_MSSQLException: TDS Protocol error

Error while invoking backup_MSSQLException: TDS Protocol error

java.sql.SQLException: TDS Protocol error: Invalid packet type 0x64 at

​

Based on the Email screenshot it looks like you have the "TDS Protocol Error" message. We have seen this message occur under different situations and mostly it is a SQL or network related issue. 

* You have network connection issue between the application and the SQL server.

* There is another backup happening when the application tries to back up the database.

In most cases, when you re-schedule the backup to a different time (outside of operational hours), the issue will be resolved. 

If you continue to receive such backup failures even after scheduling it to different hours, please keep us posted.


      New to ADSelfService Plus?

      Start your free trial

        Resources

            • Related Articles

            • SQL Backup permission post 10.6 Upgrade.

              Error on the logs: [20:00:50:193]|[04-25-2022]|[com.adventnet.taskengine.backup.DbBackupTask]|[INFO]|[124]: BackupStatus updated in DB :: <BackupStatus backup_id=1806 backupType="FULL_BACKUP" ...

            • How do I restore the backup data?

              NOTE: For builds > 10.6 While migrating to different database you can use backupdataold.bat / backupdataold.sh. Here backup will be in .data format and this can be restored in across DB platform. While restoring .data file we have to use below ...

            • Restore fails due to CRC error

              When the Backup is Password protected, then during restore, the application is unable to unzip the backup file due to CRC error below, Default Backup password: SDP123! java.io.IOException: invalid CRC (MAC) for file: ...

            • Scheduled Backup Failure

              Sometimes the scheduled backup fails due to the below error in the logs, Error Message org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at ...

            • How to take a backup in SDP-MSP

              Note: In 10.6 when running a backup using backdata.bat/backdata.sh the backup file will be in .ezip format. Backup with .ezip format can be restored to the same database platform only. For example a backup with .ezip when taken from postgres DB ...