14
Database '%.*s' cannot be opened because either an earlier system termination left LOAD DATABASE incomplete or the database is created with 'for load' option. Load the database or contact a user with System Administrator (SA) role.
This error occurs when you attempt to reference a database:
Whose load database process has been terminated before completion, or
That was created with the for load option and that has not been loaded yet.
Eliminate the 930 error by determining which of the above situations applies to you, then follow the appropriate set of steps below.
Since the 930 error is, in this case, the result of an earlier error, the recommended action is to determine what caused the load database process to be terminated before completion.
Check the Adaptive Server and Backup Server error logs for error messages about the database in question, and try to eliminate those first by using the troubleshooting procedures in this manual. If you cannot find any procedures recommended for your specific errors in this manual, call Sybase Technical Support for assistance.
Examine your operating system error log to determine if hardware errors may have caused the corruption. If errors of this type occurred, solve the problem that caused them.
Enter the load database command again.
Load the database before you try to reference it.
If you do not have enough space allocated to the specified database and get Error 3105 when you attempt to load the database, use one of the following methods to increase the size of the database to be loaded:
Drop the newly created database first and then re-create it with the size specified in the error 3105 message. If you cannot drop the database with drop database because the database has been marked suspect, and you are getting error 926, the instructions in “Dropping a database when drop database fails” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery guide.
or:
Use the command alter database db_name for load.
To avoid 2558 errors or a remapped database, the database being loaded into must be identical to the dumped database in terms of data, log, and segment mapping. Refer to “Error 2558” for more information.
If the specified database is the default database for a certain user, that user will get errors 930 and 4001 and will be put in the master database when they connect to the Adaptive Server. Use the following command if you want to change that user’s default database:
1> sp_modifylogin <user_name>, defdb, <database_name> 2> go
Before calling Sybase Technical Support, have the information listed in “Reporting errors” available, including the output from:
select * from master..sysusages
select * from master..sysdatabases
All versions
