cancel
Showing results for 
Search instead for 
Did you mean: 

Data on dump will not fit into current database

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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"

former_member188958
Active Contributor

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

former_member188958
Active Contributor
0 Kudos

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