Configuring Database Servers

Depending on your setup and situation, you might need both to set the recovery model for your SQL Server databases and to make sure your database servers are linked (if you are using multiple database servers during synchronization).

Setting the Recovery Model

Before you synchronize customizations, we recommend that you set the SQL Server recovery model for the Target forms database to Simple. With this setting, there is no risk of filling a transaction log during synchronization and thereby generating an error.

For instructions to set the recovery model, see the SQL Server Enterprise Manager documentation.

When the Source and Target Databases Reside on Different Servers

To synchronize customizations when the Source and Target forms databases reside on different servers, the server that contains the Source forms database must be defined as a linked server in the server that contains the Target forms database.

For instructions to configure linked servers, see the Microsoft SQL Server documentation.

Note: In a configuration, local is an invalid server name. You must use the name of the SQL Server instance on the local machine.