Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008

    Unanswered: Problem with loading dumps

    i have a sybase 12.5.x dump. i wanted to load it into a sybase 15.0.x.

    Jul 01 09:53:57 2009: Backup Server: Attempting to open byte stream device: 'compress::\Backup\restore\dump.dmp::00'
    Jul 01 09:53:57 2009: Backup Server: The database page size of 4096 bytes obtained from ASE is different from the database page size of 2048 bytes read from the dump header. The LOAD session must exit.
    Jul 01 09:53:57 2009: Backup Server: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.

    is it because i have setup the server or the database wrongly with the different pagesize?

    is there any way i can remedy without re-installing sybase?

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Yes you must use same pagesize
    recreate the instance using srvbuild

  3. #3
    Join Date
    Mar 2007

    pagesize on dump/load

    use bcp to init the data for your migration, or change the page size
    I suggest using bcp and leave your pagesize at 4096.

Posting Permissions

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