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.
How to disable the transaction log file
Re: How to disable the transaction log file
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??
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??
Re: How to disable the transaction log file
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?
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?
Re: How to disable the transaction log file
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?
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?
Re: How to disable the transaction log file
What about "Set logbackup off"?
Regards,
Rainer
Regards,
Rainer
Who is online
Users browsing this forum: No registered users and 10 guests