Question Re: dbunload on striped backup in Technology Q&A

dbunload on striped backup

Former Member — Mon, 08 Jul 2019 08:20:26 GMT

Good morning,

I have received a striped backup of Sybase 11.10 and I would like to retrieve the data on my computer.

The dump was created with the following command line:

dump database test to "/dump/$ISODATE-l0-test-s0.db" *

stripe on "/dump/$ISODATE-l0-test-s1.db"

stripe on "/dump/$ISODATE-l0-test-s2.db"

stripe on "/dump/$ISODATE-l0-test-s3.db"

I have tried to unload database with SQL Anywhere 12 (Sybase Central Wizard) and the command line :

dbunload -v -c "UID=sa;PWD=***;DBF=C:\Sybase\2019-04-18-l0-test-s0.db DBF=C:\Sybase\2019-04-18-l0-test-s1.db DBF=C:\Sybase\2019-04-18-l0-test-s2.db DBF=C:\Sybase\2019-04-18-l0-test-s3.db" -r "C:\Users\Administrator\Documents\reload.sql" -ii -up "C:\Users\Administrator\Documents\unload"

but it seams that it does not take into account striped backups, only a single db file.

Do you have any suggestion how to perform a dbunload on a striped backup or any other ideas ?

Thank you for your help,

Agnieszka

Re: dbunload on striped backup

chris_keating — Mon, 08 Jul 2019 14:17:46 GMT

I assume that the source database is ASE (Adaptive Server Anywhere) given the DUMP DATABASE. You would not use SQL Anywhere tools if the source database is not SQL Anywhere. I would encourage you to ask this question with the correct product Tag given that DUMP DATABASE is not a SQL Anywhere function.

Re: dbunload on striped backup

former_member186998 — Tue, 09 Jul 2019 06:23:39 GMT

Do you expect a striped backup for SQL Anywhere database?
Unfortunately, SQL Anywhere does not have such a function.