Restore

Hello v_pozidis, we cannot restore a database that is in use. You need to close the application and copy "sqlite.db" from the backup and paste it in your program folder in order to replace the existing one.
Destiny

I had already used a Batch file some time ago but I abandoned the idea because the database file is not replaceable in use of this one.

Try this one.

Form1.close; // will also close the database

// replace database with the selected backup
CopyFile(OpenDialog.FileName, ExtractFilePath(Application.ExeName)+'\sqlite.db');

// re open the application
OpenFile('samplebackup.exe');

Just a hunch that closing the main(Form1 in the sample) form will also close the database connection, then after that, you can replace the sqlite.db by the backup. Then running the executable afterwards.

What I can not understand is that if the program runs the database is active. So with your example when you close the program Form1.close how does the function replace works???

You must first backup the database using the backup button. The button will backup your current sqlite.db to [filename].dbbak using SaveDialog

Then the Add record button is just to populate the table to see if populated table will be replaced by the backup.

To backup, you then click Backup button in which the program will ask the user for a file(backup, the one you save with Backup button) using the OpenDialog, then when the user select [filename].dbbak, it will close Form1, then replace sqlite.db with the user's selected [filename].dbbak, then reopen the program