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

    Unanswered: load database from backup

    Hi guys,

    is there additional command for load backup to verify amount of size needed to load the backup file.


    TIA.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I am not sure if it is still a command, but you can look into
    Code:
    LOAD DATABASE dbname FROM FILE = filename WITH LISTONLY
    from the backup file. This should give you a list of the files, as well as their sizes.

    Ref: http://infocenter.sybase.com/help/in...nds/X28090.htm

  3. #3
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    The load command is

    load Database ARSystem from '/sybdump/ARSystem_14042014_latest.dmp'

    and also from the location where you are trying to load the dumps , you can run "l s-lrth " and get the dump file size

    -r-------- 1 sybase sybase 136083456 Nov 9 2011 ARSystem.db.111109102157.gz


    So check that it may get you the size .

    As you are trying to load the backup taken from the same database , it is not a problem to reload the dump

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Quote Originally Posted by rmajeti View Post
    The load command is

    load Database ARSystem from '/sybdump/ARSystem_14042014_latest.dmp'

    and also from the location where you are trying to load the dumps , you can run "l s-lrth " and get the dump file size

    -r-------- 1 sybase sybase 136083456 Nov 9 2011 ARSystem.db.111109102157.gz


    So check that it may get you the size .

    As you are trying to load the backup taken from the same database , it is not a problem to reload the dump
    Actually, the size of the dumpfile does not equal the size of the database. You can have a database of 20Gb, but a dumpfile of only 5Gb.
    You will not be able to load that dumpfile in that database.

    With the LOAD DATABASE dbname FROM FILE = filename WITH LISTONLY command you can verify how much space you need in your db and how it should be defined (how much data and how much log, and in what order).
    I'm not crazy, I'm an aeroplane!

  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Use with headeronly i.e.
    load database dbname from '/dirname/filename' with headeronly

Posting Permissions

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