Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the steps to minimize unwanted changes to the database when I run the synchronization script?

April 26, 2017changes database run Script steps synchronization unwanted

0

10 Posted

What are the steps to minimize unwanted changes to the database when I run the synchronization script?

1 Answer

0

10 Posted

• Make sure that Include Transaction Handling in Synchronization script option of the Synchronization Wizard is turned ON. • Backup Database Before Synchronization option of the Synchronization Wizard should be set to either Use Default Backup Directory or Use This Directory value. This will create a backup immediately before the synchronization is performed. • Set the altered database to Full Recovery Mode. This will allow using recovery tools like ApexSQL Log if any data is lost.