BUG: sp_create_removeable Stored Procedure Fails with Error 5104

ID: Q185961

The information in this article applies to:

Microsoft SQL Server version 6.5

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.

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 : SSrvAdmin SSrvSQL_Admin SSrvStProc kbbug6.50
Version : winnt:6.5
Platform : winnt
Issue type : kbbug