Error 930

Severity

14

Message text

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.

Explanation

This error occurs when you attempt to reference a database:

Action

Eliminate the 930 error by determining which of the above situations applies to you, then follow the appropriate set of steps below.


Previous load database failed

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.

  1. 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.

  2. 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.

  3. Enter the load database command again.


Incorrect use of create database for load

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:

or:

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

Additional information

Before calling Sybase Technical Support, have the information listed in “Reporting errors” available, including the output from:

Versions in which this error is raised

All versions