I didn't remove the file. This question is part of a "disaster recovery" from scratch with a entire recover of Sun Solaris. The sybase server runs actually on Fiber Channel disk in a separate box. We want only recovered one database (+/- 100Gb).
I know that we can retrive this information in the errorlog of the server.
Do we retrieve this information in other place that in the errorlog ? (especially in the comumn status of sysdevice table)
Originally posted by xavier_urbain
Is there a special status in sysdevices to see that this device is not anymore accessible ?
I don't think there is anyway of knowing that a device is unavailable using standard documented commands. There is no status bit available in any of the system tables that tell the server the health of a device at all times.
This is done only during startup and then again if server requests a page that is hosted on that particular device.
Check with Sybase Support, they might have some un-documented dbcc's