on 2014 Aug 01 2:33 PM
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
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.