Taken a full backup in 7603, then taken to another machine to test it.

Problem is the restore fails as below:
====================QUERY = INSERT INTO HolidayDefinition (HOLIDAYDEFINITIONID,H
OLIDAYDATE,DESCRIPTION,SITEID,ISRECURRING) VALUESnull
java.sql.BatchUpdateException: Data truncation
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:404)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:141)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:91)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Data truncation
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:404)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:141)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:91)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : Data truncation

C:\ManageEngine\ServiceDesk\bin>

What can I do in the orginal system so the backup will take a good one and then I can restore - as I assume I can't get the restore to work as it is.

Not urgent today - BUT if we have a disaster then I won't be able to restore and it will become a major issue.

Thanks,
Andy