248
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.
Note This error may be caused by a hardware problem.
CHAPTER 3 Error Message Writeups
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:
• A database device is offline.
• A database device or file has been removed or renamed.
• A database device or file is inaccessible to Adaptive Server for any other
reason, such as insufficient permissions.
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 will not be able to recover any databases that have space
on the device upon restarting because an 840 error will mark the databases
suspect. If you know that the databases were marked 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 “How to Reset
a Database's “suspect” Status” in the Encyclopedia of Tasks chapter.
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
writeups for those errors in this manual. If errors still persist, call Sybase
Technical Support.