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

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
                                
Full    Othr 2  Arch    D:\xxx\xxx.bak
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               xxx.db                                                               A


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


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

 } Ã÷ Ðzf¤    .Ü§                                                                                             €        ddýá               ÿÿÿÿÿÿÿÿ  f¤        ÿÿÿÿÿÿÿÿ}
           ÿÿÿÿÿÿÿÿÝÿ?                        æ                                                                                                    ÿÿÿÿÿÿÿÿ
``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
      ¿     =    ¢ W 
 Ãt*á–Iû¯dÌv(ÛBò¦W¿ 
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  Œ                                       ul_userBASENSA

     O               :   :   ;                      
SYSREMOTEUSERBASENSA

upgrade

asked 01 Aug '14, 13:33

Breck Carter
32.5k●539●724●1050
accept rate: 20%

edited 01 Aug '14, 13:37

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

(01 Aug '14, 13:43) Graeme Perrow

flat view

Be the first one to answer this question!

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

upgrade ×62

question asked: 01 Aug '14, 13:33

question was seen: 11,472 times

last updated: 01 Aug '14, 13:43

SAP SQL Anywhere

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

Follow this question

Related questions