Skip to main content

Defining Microsoft SQL Server database settings

Set the following for the Microsoft SQL Server database(s) that you are using as a source:

  • From the Object Explorer in the Microsoft SQL Server Management Studio, right click the database and select Properties. In the Options tab, set the Recovery model to Bulk logged or Full. In this mode, the transaction Log is more durable and truncation occurs less frequently.
  • Ensure that there is a full database backup for each Microsoft SQL Server database that you are using as a source.
  • When creating a connection string, it is possible to use any parameter supported by Microsoft SQL Server. The Microsoft SQL Server system administrator must ensure that the Microsoft SQL Server instance is configured correctly so that the proper authentication credentials are accepted.
  • To be able to work with MS-REPLICATION, each of the source tables must have a primary key.