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?