Skip to Content
avatar image
Former Member

Data on dump will not fit into current database

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 18, 2017 at 10:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2017 at 03:57 AM

    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"

    Add comment
    10|10000 characters needed 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