BUG: sp_create_removeable Stored Procedure Fails with Error 5104 (185961)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB185961 |
|---|
|