Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2012
    Posts
    3

    Unanswered: Help ata on dump will not fit into current database ASE

    Hello, I'm trying to restore a database from file using sybcentral, but I get this message

    -- BDTEC Restore Messages
    Backup Server session id is: 48. 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 'BDTEC112840C5E5 ' section number 1 mounted on disk file '/opt/sybase/BDTEC_11_Oct_2011_14PM' Data on dump will not fit into current database. Need 1894 Mbyte database.

    I have the file in /opt/sybase/BDTEC_11_Oct_2011_14PM, also I create a databse, then do the backup and restore an I get the same message. Iwas thinking if I have to create a database device with that size to do the restore but I'm not sure, please Does anybody know how to solve it? please, help mee!!

    I'm using Sybase ASE 15.5.

    Thank you

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Your target database should be the same size as the original from the dump.
    The sum of all the data and log segments should equal 1894 MB
    to see the segment sizes
    load database your_db from '/opt/sybase/BDTEC_11_Oct_2011_14PM' with headeronly

  3. #3
    Join Date
    Feb 2012
    Posts
    3
    Quote Originally Posted by pdreyer View Post
    Your target database should be the same size as the original from the dump.
    The sum of all the data and log segments should equal 1894 MB
    to see the segment sizes
    load database your_db from '/opt/sybase/BDTEC_11_Oct_2011_14PM' with headeronly
    Yea I know but, How can I do that? I've tried to something like:
    create database DB on default = 2000 M
    but the message appears anyway, could show me how to create the database?
    thanks a lot.

  4. #4
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,
    It would be usefull if you knew the previous database data and log size.
    That way the segments will be loaded correctly. Like so:

    Create database [name] on [logical datadevice name]='[size in MB]M' , log on [logical logdevice name]='[size in MB]M'

    Create database Test on datadev1 ='1500M',
    log on logdev1 ='500M'

    Or
    Like your suggesting:

    create database Test
    on default = "2000M"

  5. #5
    Join Date
    Feb 2012
    Posts
    3
    Yes I already solved it, I had to create a database device with 2000 Mbytes, then I did (where DBD is the name of the new database device):
    > CREATE DATABASE DB on DBD = 2000
    >go

    then I did successfully the restore,

    Thanks anyway

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •