The information in this article applies to:
SYMPTOMS
A device activation error may occur if a device is dropped, then a
subsequent disk init incorrectly reuses the same vdevno. However, the 5105
error issued is misleading as to the true cause of the error.
The SQL Server errorlog will also have the following entry:
The physical file created by the failed disk init will exist on the disk, but the device will not exist in SQL Server. For example, the second disk init in the following script will fail:
After this script runs, both the files TEST5105.DAT and NEXT5105.DAT will exist in the c:\ directory. With this error, it would be better for SQL Server to issue a 5104 message:
WORKAROUND
Rerun the disk init command with a new vdevno and a new physical file
name. If the SQL Server is shutdown and then restarted, the physical
file that was created by the disk init, which failed with the error 5105,
can be deleted manually, and the name respecified.
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.2. This problem does not occur in version 6.0.
Keywords : kbother kbbug4.20 kbbug4.21 kbbug4.21a SSrvServer SSrvWinNT |
Last Reviewed: March 18, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |