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