Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Corrupt data device

    We got a few databases marked as suspect because of a device error. Following is from the error log:

    Msg 840, Level 17, State 1:
    Device 'dev_data_device'(with physical name 'D:\data\dev_data_device.dat', and virtual device number 9) has not been correctly activated at startup time.
    Please contact a user with System Administrator (SA) role.

    Can anyone advice if there is anything that be done other that dropping the device and rebuilding all the databases on this device?



  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    You could attempt a salvage operation. However, the steps are beyond the scope that can be discussed and done via online forums.

    I just contacting Sybase tech support, to guide you through the salvage operation. Depending on the extent of corruption, salvage may have some data loss.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts