Can't Restore Database (MS SQL 2005/SD+ 7012)

Can't Restore Database (MS SQL 2005/SD+ 7012)

Hi,

In order to attempt, once again, to upgrade from 7012 to 7018 (many attempts later...), we built a fresh virtual Windows 2003 Server. Then installed SD+7012 with the MS SQL option. Started SD+ 7012 and it went fine. Tried to restore my lasted backup from my production SD+ and it produce the following error:

Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
========QUERY = INSERT INTO assetnotification (ASSETNOTIFICATIONID,ASSETNOTIFICA
TIONNAME,ISENABLED,ESCALATETOID,ESCALATEBEFORE) VALUESnull
java.sql.BatchUpdateException: Invalid column name 'ESCALATEBEFORE'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Invalid column name 'ESCALATEBEFORE'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Invalid column name 'ESCALATEBEFORE'.






























Production Server:

- ESX Server
- Windows 2003 Server
- MS SQL 2005 (separate production server)
- HTTPS with 3rd party SSL

Test Server:

- ESX Server
- Windows 2003 Server
- MS SQL 2005 (separate test server)
- HTTP port 8080

What can we do to get this restore to complete successfully?

Thanks!





















                    New to ADSelfService Plus?