pcsoft.us.windevCopyright 2026, PC SOFT11 Oct 2017 16:23:00 Z7 Oct 2017 20:09:00 ZHello All, At this moment I am busy developing an automated backup program for my customers. Till now only the creation of the full backup is accomplished, restoring is still failing. For testing purposes I use the simplified code below: MyConnection is Connection HCloseConnection(MyConnection) HRestoreBackup(MyConnection,DataPath) But if I try to restore, I get the following error (DESKTOP = my own machine): Error returned by < Server:4900> server: You cannot restore the < Database> database because the < MyConnection> connection opened from the < DESKTOP> computer for the < admin> user uses this database. It looks like a pretty straightforward issue, as I still have some sort of connection open to the database. But this is certainly not the case, as my code suggests above. I tried multiple things with disconnecting the connections with HFSQL Control Center, although this had no effect whatsover. I already looked at the "WD Duplication" example which didnt even require a disconnect. Any tips or solutions will be appreciated! Regards, Rik30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62924/read.awp11 Oct 2017 16:23:00 Ztry HRestoreBackup(MyBackupConnection,DataPath) regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62924/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62924/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62905/read.awp10 Oct 2017 15:34:00 ZHi Fabrice, There is no connection defined in the project analysis. Regards, Rikhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62905/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62905/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62896/read.awp9 Oct 2017 19:54:00 ZHi again there is also the possibility of a connection defined in the analysis. If there is one, remove it. Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62896/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62896/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62878/read.awp9 Oct 2017 10:44:00 ZHello Fabrice, Thank you for you response. The USE instruction is not doing the trick. With this new insight I can probab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62878/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62878/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62877/read.awp8 Oct 2017 23:06:00 ZHi Rik, it looks like a case of multiple connections inside your application. You have to understand that: - each independe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62877/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62877/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62874/read.awp8 Oct 2017 16:35:00 ZHello Walter, Thank you for your fast response. That was my first test case, but didnt help either. Regards, Rikhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62874/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62874/read.awpHRestoreBackupguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62872/read.awp8 Oct 2017 14:15:00 ZHi Make sure the HFCC program is closed and try againhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62872/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62870-hrestorebackup-62872/read.awpHRestoreBackup