- Getting Error 840 with state 2 in ASE errorlog and cannot recover the database.
Error: 840, Severity: 17, State: 2
Device 'tdblog2' (with physical name '/…/XXX/YYY/tdblog2', and virtual device number 12) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
- Log device file tdblog2 is missing, it may have been deleted accidentally.
- Create an empty file with missing log device file name tdblog2 may workaround 840 error. However, "dump database" fails with 8009 error. Both ASE and backupserver report ‘dd_read’ error due to new empty log device file tdblog2.
SAP Adaptive Server Enterprise 16.0
error 840, missing log device file, sysusages, log hole , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.