Cannot open log file 1

[doomdumas]

Thanks for reading,
There is the facts :
SQLBase Engine is running SERVER1
Into SQLTalk : SET SERVER SERVER1; ok.
The server seems sucesfully installed (LOCAL).
When I try CONNECT DatabaseName; in SQLTalk,
it's fails : Cannot open log file .
But there is no log file with the DBS.
That database is from an old system, was stopped six month ago, so I could'nt UNLOAD DATABASE from the source where the .DBS was. I really need to read this DB !
Help will be extremely appreciated and almost life saving ;-)
Thanks in advance,
Dominique

 

[ManuelPallas]

okay the problem is that there are missing important log-files for this database!
try to use the rollforward-command( look into sql-talk-help for the parameters) to kick the log-files that are missing ;-)

 

[Paradox3]

BUT the fact is you can't get connected to the database to issue the Rollback command against it. IS there a way around this?!?!? I also am in dire straits with Centura SQLBase 7.0.1 database receiving this error.
"Cannot open log file". I can connect to the default database (island) just fine. ANY help would be greatly appreciated!!

 

[ManuelPallas]

for a rollforward-command you don´t need a database-connection. in this case you need only a server-connect with set server!
Script example:

set server xxxx;
rollforward *databasename* *Parameter*;

thats all. when get luck, you will get your database back!

 

[DerLoneWolf]

Hello

Here´s a good Way to go:
Try the following:
Get into SqlTalk
When the dialog appears that asks for Database, User and Password, click "Cancel" You will still be in SqlTalk. Type the following commands into SqlTalk;
Set Server <put_your_server_(not_database)_name here>;
Rollforward <put_your_database_name_here> to end;
SqlBase will say some things here. Ignore it
Rollforward <put_your_database_name_here> to end;
Yes, this is the same command as in 4) above executed again.
SqlBase will now say something like: "The log file 22.LOG could not be found.
Use the RESTORE LOGS command to restore this log and continue the rollforward process.
If this log is not available,use the ROLLFORWARD <database> END command to complete the recovery process." Ignore this also (unless you DO have access to the logs...).
Rollforward <put_your_database_name_here> end;
SqlBase will respond with "rollforward completed" You should now be able to connect to your database.

Have Fun

LoneWolf