[h2] Re: Corrupted databases revisited

2019-04-25 Thread Evgenij Ryazanov
There is a DB_CLOSE_ON_EXIT setting. It in enabled by default, but it can be disabled. SHUTDOWN command may be executed with other alive connections, they will be closed too, but it's possible that an application will reopen the database after execution of this command, you need to prevent it

[h2] Re: Corrupted databases revisited

2019-04-25 Thread Silvio
Thank you for the response Evgenij, On Thursday, 25 April 2019 15:46:30 UTC+2, Evgenij Ryazanov wrote: > > Hello. No, you can't copy a database file if database was not closed > properly, but you can use a SHUTDOWN command to close it. > Ok, so that means that closing all connections is not

[h2] Re: Corrupted databases revisited

2019-04-25 Thread Evgenij Ryazanov
Hello. No, you can't copy a database file if database was not closed properly, but you can use a SHUTDOWN command to close it. However, if you need a backup copy it can be created with BACKUP TO 'filename.zip' command, there is no reason to close other connections for it. Usually it's safe to