Hi,

I want to recover a database by using the transactionslogfile.
I have an image-backup (made by dbbackup.exe) and a modified database.

I want wo recover the modified database by using the image-backup and the current Logfile.

How do I proceed:
- I copy the image-backup to new directory (%VDBR%)
- I use dbtran.exe to validate the Logfile of the image-backup.
"%ASANYBIN%\dbtran.exe" -a -q -y "%VDBR%\db_test.log" "%TEMP%\dbtranS.sql"
- then I start the image-backup-Database with "-a" and the Logfile of the image-backup to commit uncommited operations .
"%ASANYBIN%\dbeng11.exe" -ca0 -c256M -n db_recover "%VDBR%\db_test.db" -a "%VDBR%\db_test.log"
- after this I use dbvalid with START-Option "dbeng11.exe -r ..."
"%ASANYBIN%\dbvalid.exe" -c "START=%ASANYBIN%\dbeng11.exe -r -ca0 -c256M;DBN=db_valid;
DBF=%VDBR%\db_test.db;UID=DBA;PWD=*****;ASTOP=YES; LOG=%TEMP%\valid.prot"
-then I copy the Logfile of the curent database into the new directory (%VDBR%) and then I repeat the procedure with this file
"%ASANYBIN%\dbtran.exe" -a -q -y "%VDBR%\db_test.log" "%TEMP%\dbtranA.sql"
"%ASANYBIN%\dbeng11.exe" -ca0 -c256M -n dbrecover "%VDBR%\db_test.db" -a "%VDBR%\db_test.log"
"%ASANYBIN%\dbvalid.exe" -c "START=%ASANYBIN%\dbeng11.exe -r -ca0 -c256M;DBN=dbvalid;
DBF=%VDBR% \db_test.db;UID=DBA;PWD=*****;ASTOP=YES;LOG=%TEMP% \valid.prot"


So... Is this approach corect? If not... please say what I should change. Should I use the "-ad"-Parameter to recover the Logfile if I have to use more than I file?

But If I do so (look above) I get an error at the first dbvalid. (SQL-error -304) with text "acceess denied"
and "disk full". I use SA 11.0.1.2308

greets
Ingmar