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 |
That certainly does look like an archive backup file. Can you email the file to me?