Error 840

Severity

17

Message text

Device '%.*s' (with physical name '%.*s',  and virtual device number %d) has not been correctly activated at startup  time. Please contact a user with System Administrator (SA) role.

NoteThis error may be caused by a hardware problem.

Explanation

This error can occur when Adaptive Server is unable to access a device during startup.

This error can occur for any of the following reasons:

Action

  1. Examine the availability and condition of the device involved using your standard operating system procedures, and make sure the device is accessible.

  2. Adaptive Server cannot recover databases that have space on the device upon restarting because error 840 marks the databases as suspect. If you know that the databases were marked as suspect because the device was unavailable, resolve the problem with the device and reset the status of the databases to allow recovery to continue.

    WARNING! Do not use these procedures if other errors in the error log near the 840 error message suggest that the databases may have been marked suspect for some other reason.

Reset the suspect status using one of the methods supplied in “Resetting a database’s “suspect” status” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery.

After you reset the status, execute the dbcc checkdb and dbcc checkalloc commands for the affected databases to ensure that no other damage was caused by the device being unavailable. If other errors occur, refer to the write-ups for those errors in this manual. If errors still persist, call Sybase Technical Support.

Versions in which this error is raised

All versions