INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Cannot open log file

Cannot open log file

(OP)
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

RE: Cannot open log file

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

RE: Cannot open log file

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!!

RE: Cannot open log file

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!

RE: Cannot open log file

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close