Restoring a Sybase Backup

[DriveByCheckmate]

Hello,

I have a backup with the extension ".db" and a log file with the .txt extension and I'm 99% sure it's a Sybase backup or the data files themselves. I need data from one table in that database into Microsoft SQL and am not sure how to access the .db file.

Is it possible for me to connect to this with a simple ODBC connection or do I need to restore it into some server type software (similar to detach / re-attaching in MS SQL)?

If so, does anyone have any suggestions on how to do this without buying a copy of Sybase?

Thanks for the help!!

 

[DriveByCheckmate]

Anyone have any feedback on this? Thanks

 

[DriveByCheckmate]

One more comment on this - I was able to download the developer version of SQL anywhere and I have the .db and transaction log file but I'm unsure of what to do next.

One thing that looked close to right, was the function that allows you to unload a database into a new database file. Am I on the right track? Do I need a database user name and password to restore from a file like this?

Thanks in advance.

 

[DriveByCheckmate]

One more...

I was able to take the db file and use Sybase to unload the database into a new database AND it seemed to be working properly - then I got an exception - see below;

Unloading "DB1"."Worksheet" (6943 rows)
Unloading "DB1"."TransactionEntries" (12125407 rows)
***** SQL error: Statement interrupted by user
***** SQL error: I/O error Fatal error: Unknown device error -- transaction rolled back
Creating indexes
***** SQL error: Statement interrupted by user
***** SQL error: Not connected to a database

----

Anyone have any feedback on this error?

A few more comments..
-It looks like this table is pretty huge and it's sucking up a lot of RAM but nothing that I'd think would stop it from working (2 gigs of ram on my machine and I shut down everything else that was hogging it).
-I have more than enough disk space to do this
-Possible that the file is corrupt? I think the other times I did this it said a different number of rows..?

Thanks for the help.

 

[PDreyer]

Maybe you should ask in a SQLAnywhere group
I could not find one on this site.
Maybe try the newsgroup sybase.public.sqlanywhere.general at

http://forums.sybase.com/cgi-bin/we...=true&group=sybase.public.sqlanywhere.general

 

[DriveByCheckmate]

Hi PDreyer,

Thanks for the feedback - I'm so unfamiliar with the product I didn't know the difference.

I did end up getting it to work... It was just a bad backup.

Thanks