16
Could not find enough space on disks to extend database %.*s.
This error occurs when an alter database command refers to an Adaptive Server device that is completely full.
If the device is not full but has less space than the alter database command requests, the database will be extended to fill up the available space on the device and no error message will be displayed. Instead, you will see the usual status message from alter database, but it will report fewer pages than you requested.
This error message does not usually appear in the error log. However, if the exhausted device also uses up the available physical disk drive space as well as the space allocated for Adaptive Server, kernel messages declaring the file system full will occur in the error log. If this happens, fix the file system problem as well as the lack of space for Adaptive Server.
To recover from error 5006, perform one of the following procedures:
Use a device name in the alter database command that is large enough. Use sp_helpdevice and sp_helpdb to find out which devices have enough room.
Add a new device to Adaptive Server using the disk init command, then refer to the new device using the alter database command.
Although there is no particular performance benefit to keeping a database entirely on one device, if you need to do this at a site, use this procedure:
Back up all the databases on the device using the dump database command.
Drop the device using sp_dropdevice.
Initialize a larger device using disk init.
Create the old databases on the new device using standard procedures. It is important to create the databases exactly like the old ones or errors will occur. Refer to “Error 2558” for more information.
Reload each database with the load database command.
Use the online database command for each database to make the databases available for use.
Refer to “Developing a Backup and Recovery Plan” in the System Administration Guide: Volume 2 for information about how to safely create, dump, load and re-create databases.
All versions
