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

asked 01 Aug '14, 13:33

Breck%20Carter's gravatar image

Breck Carter
26.2k430599862
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
Be the first one to answer this question!
toggle preview

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

Question tags:

×54

question asked: 01 Aug '14, 13:33

question was seen: 10,319 times

last updated: 01 Aug '14, 13:43