How to disable the transaction log file

Discussion forum about all things SqlBase or SqlTalk
Mike Vandine

Re: How to disable the transaction log file

Post by Mike Vandine » 13 Apr 2011, 05:05

I see the confusion you are having.

recovery on/off is specific to a particular *connection*. If you turn it off using SQLTalk, it will remain off until it is turned back on by that SQLTalk session or the SQLTalk session is ended. To set recovery off you must be the only connection to the database, except another session that might have the database open, also with recovery off. Any further connections to the database while recovery is off MUST connect with recovery off as well.

So, if you have turned recovery off in SQLTalk (leaving the session open) and then try to connect with a program that uses the default connection (recovery ON), that connection will fail. Once the SQLTalk session has ended, recovery is set back to ON for the database and the other connection can be made, but it will be made with the recovery on.

dis_sg

Re: How to disable the transaction log file

Post by dis_sg » 13 Apr 2011, 05:16

Hi,
what i did
1, open sqltalk, connect db, set recovery off,disconnect and close the sqltalk.

2, open sqltalk ,connect db and run "show recovery;" it show the recovery is disable.
disconnect db, close the sqltalk

3, i assume that the db is in recovery off mode.

4, open the conversion program and connect the database, the transaction log was created.
does it mean that when connect the db from the conversion program, the recovery mode is on again?
may i know how to connect db with recovery off??

dis_sg

Re: How to disable the transaction log file

Post by dis_sg » 13 Apr 2011, 05:21

Hi,
just confirm that the recovery is set to ON when conversion program is running
trying to put the statement,"set recovery off" on the script where the conversion program executed but failed.

any idea how to fix it?

Mike Vandine

Re: How to disable the transaction log file

Post by Mike Vandine » 13 Apr 2011, 05:54

You can set recovery off programmatically or from within SQLTalk. If you have a SQLTalk script that you set this in, the run a program (i.e. execute a program from within the SQLTalk script) recovery will not be off!

As far as I know there is no way to do what you want to do. If the conversion program connects with recovery on, you can not get it set off outside of the program and have it run.

How about showing me the script? This is run using SQLTalk, right?

RainerE
Germany
Posts: 2223
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: How to disable the transaction log file

Post by RainerE » 13 Apr 2011, 10:22

What about "Set logbackup off"?

Regards,
Rainer

Return to “SqlBase General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests