Skip to Content
0

Data on dump will not fit into current database

Oct 18, 2017 at 08:22 PM

273

avatar image
Former Member

1> load database DEV from "e:\QAS.DB"

2> go

Backup Server session id is: 9. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 6.28.1.1: Dumpfile name 'QAS172900AFB8 ' section number 1 mounted on disk file 'e:\QAS.DB.asd' Msg 3105, Level 16, State 4: Server 'DEV', Line 1: Data on dump will not fit into current database. Need 507712 Mbyte database.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bret Halford
Oct 18, 2017 at 10:29 PM
0

Typically this message means exactly what it says, you need to create a database at least as large as the message
indicates in order to load the dump.

How big is the database currently?

-bret

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 19, 2017 at 03:57 AM
0

database approximately 500 GB

i should use this

disk resize name = "DEV_data_001", size = "507712M"

or

alter database DEV on DEV_data_001= "507712M"

Show 1 Share
10 |10000 characters needed characters left characters exceeded

If the database is already approximately 500GB, you only need to alter it by the difference between what is needed and the current size. (i.e. if the database is currently 500000M in size, you need only enlarge it by another 7712M).

If the device doesn't have that much free space, you would need to first either
a) resize the device by at least the amount of extra space needed or
b) alter onto a different device that has enough free space or
c) disk init a new device and alter onto the new device

1