Error 3105

Severity Level 16

Message Text

Data on dump will not fit into current database. Need %ld Mbyte database.

Explanation

An attempt was made to load a database dump into a database that is not as large as the dumped database. You cannot use DUMP DATABASE or LOAD DATABASE to shrink a database, regardless of the amount of actual data in the database.

Action

If your goal is to load the database from the dump, you must increase the size of the destination database to at least the configured size of the dumped database. You can do this using either the ALTER DATABASE statement or by dropping the database and then creating a larger one.

If your goal is to shrink the total size of a database, you cannot use DUMP and LOAD. You must copy all the data out of the database using bcp, drop the database, create a smaller database, create the database structure with scripts, and then reload the data with bcp.

If the destination database does not have identical data and log mapping, and identical segment mappings, as the dumped database, error 2558 might also occur. For additional information about segment mapping, see the description of error 2558.