Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restoring a Sybase Backup

Status
Not open for further replies.

DriveByCheckmate

Programmer
Jun 2, 2008
19
US
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!!
 
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.
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top