17
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.
This error may be caused by a hardware problem.
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
Examine the availability and condition of the device involved using your standard operating system procedures, and make sure the device is accessible.
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.
All versions
