Back up error – TDS Protocol error

Exception when the periodic backup runs

java.sql.SQLException: TDS Protocol error: Invalid TDS data type 0x74 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2284) at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:765) at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:593) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBackUp.java:1325) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1201) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:396) at

 

Solution :

It looks like network related error.
We found similar case where the database Backup location or attachments is located in another drive or machine. For such case , we recommend to save the database back up in the same machine. If you are using MSSQL as database , please take periodic SQL inbuilt backup option which will be fast to restore at any point of time.

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500