cancel
Showing results for 
Search instead for 
Did you mean: 

How do I upgrade an 8.0.2.4293 archive backup using SQL Anywhere 16?

Breck_Carter
Participant
0 Kudos
11,919

I have a file that LOOKS LIKE it was created with the 8.0.2.4293 archive BACKUP (not the usual image backup). It is sitting on a machine that only has SQL Anywhere 16 installed.

How do I restore and upgrade this file? Do I need to install SQL Anywhere 8? Will SQL Anywhere 9 work?

...or am I wrong about what the file contains?

A SQL Anywhere 16 RESTORE chokes...

RESTORE DATABASE 'xxx.db' FROM 'xxx.bak.1';
Could not execute statement.
Error during backup/restore: unable to open device
D:\\xxx\\xxx.bak.1 (Unknown err status reading HDR labels)
SQLCODE=-697, ODBC 3 State="HY000"

Here are the first few bytes from the file...

VOL1000001                                                                     
4HDR1                       
000000000000000000000000000000000        
HDR2F0000000000
                                   00                            
``xxx.db
``                        ASAn

2014-07-10 07:00:00.000         DBA
                             \x01   
Full    Othr 2  Arch    D:\\xxx\\xxx.bak
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               xxx.db                                                         \x08      A


\x0f                    SYSTEM
                                                                                                                          D:\\xxx\\xxx.db                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              }\x17\x01         \x01           translog
``                                                                                                                        xxx.log
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Ä÷      
   \x01           Sybase Begin/End-of-Store Record .......xxx.db


We don't need no steekin' Easter Eggs!!!    A   ì           ^ºzÚ)

 }\x17\x01 Ã÷ Ðz\x01f¤    .ܧ\x0c                                                                                             €        ddý\x0cá\x04  \x0c             ÿÿÿÿÿÿÿÿ  f¤        ÿÿÿÿÿÿÿÿ}\x17\x01
           ÿÿÿÿÿÿÿÿÝÿ?\x01                        æ\x15                                                                               \x01                     ÿÿÿÿÿÿÿÿ
``Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293

Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase I
     \x18 ¿     =   \x01 ¢ W 
 Ã\x06t\x06*\x06á\x05–\x05I\x05û\x04¯\x04d\x04\x1a\x04Ìv(ۏBò\x01¦\x01W\x01\x08\x01¿ 
se Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., Copyright (c)2000 8.0.2.4293 
Sybase Inc., CopyrighI  Œ\x01            \x05   \x05   \x17             \x01        ul_user\x04BASE\x01NSA

     O  \x16             :   :   ;               \x01       
SYSREMOTEUSER\x04BASE\x01NSA

graeme_perrow
Advisor
Advisor
0 Kudos

That certainly does look like an archive backup file. Can you email the file to me?

Accepted Solutions (0)

Answers (0)