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

    Unanswered: Problem with loading dumps

    Hi,
    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: 4.132.1.1: Attempting to open byte stream device: 'compress::\Backup\restore\dump.dmp::00'
    Jul 01 09:53:57 2009: Backup Server: 4.177.2.1: 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: 1.14.2.2: 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
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Yes you must use same pagesize
    recreate the instance using srvbuild

  3. #3
    Join Date
    Mar 2007
    Posts
    86

    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
  •