When working with databases and Hot-Standby, there are basically these options for that structure:

•Both applications access the same database on the network. The Hot server stores data on this database

•There are two databases executing locally, on both servers, main and backup. In this case, enable the Database object's EnableSynchronization property, so that all data stored on the main database is also updated on the database in Standby mode

If the main application cannot send data to the server in Standby mode, this data remains stored locally on disk, to be sent later when communication between these computers is reestablished, thus ensuring that tables generated by the application are equal.