Microsoft KB Archive/185961

= BUG: sp_create_removeable Stored Procedure Fails with Error 5104 =

Article ID: 185961

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q185961



SYMPTOMS
When you attempt to use the sp_create_removeable stored procedure to create a removable media database, you may receive the following error:

CREATE DATABASE: allocating 1024 pages on disk '%.*s'

Msg 5104, Level 16, State 1

Device number 128 already used.

Msg 15263, Level 16, State 1

Could not create the 'data' device. See the errorlog for details.

Dropping any devices used only by this database.

This problem can occur when both of the following conditions are true:


 * There are more than 128 database disk devices on the server. -and-


 * The virtual device numbers up through and including 128 are in use.



CAUSE
The algorithm used by the stored procedure to get the next available virtual device number uses an incorrect calculation.



WORKAROUND
To avoid the problem you can drop some of the devices that are not being used.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: prodsql vdevno vdevnos vdevno's

Keywords: kbbug kbpending KB185961

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.