SEO

#1 (**permalink**) 04-08-2008, 02:52 PM

Hi,

I have a Sybase Adaptive Server Anywhere 7 database running.

I have a database file that is dated june 12, 2003
I have the database log file from yesterday.

The backupsoftware have not backed up the database file since june 12
because it did not back up open files.

So, can i merge my database file frome june 12 and my logfile from yesterday
and have all the changes since june 12 committed ? If, so how do i do it ?
Can't see any tools in the Sybase Central that can help me out...

This is a library database and my librarian is not happy at the moment.....

#2 (**permalink**) 04-08-2008, 02:52 PM

Hiya,

If the transaction log has not been truncated since, I'd say you can
apply the log file.

Otherwise you can force the log using dbtran and translate it to SQL
and apply the SQL to the database. This is a bit risky, you may miss a
lot of transactions since the last checkpoint until the time this log
got created.

Cheers,

Willy

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Restore of database file and log file