Help Center> Data Replication Service> Troubleshooting> Solutions to Failed Check Items> Database Parameters> Checking Whether the Source Database Uses the Full Recovery Model
Updated on 2022-12-30 GMT+08:00
View PDF

Checking Whether the Source Database Uses the Full Recovery Model

Microsoft SQL Server as the Source in Synchronization

Table 1 Checking whether the source database uses the full recovery model

Check Item

Whether the source database uses the full recovery model

Description

Check whether the source database uses the full recovery model.

Failure Cause and Handling Suggestion

Failure cause: A database does not use the full recovery model in the source database.

Handling suggestion:

Run the following SQL statements on each database that does not use the full recovery model:

USE [master]
GO
ALTER DATABASE [Database name] SET RECOVERY FULL WITH NO_WAIT
GO
Parent topic: Database Parameters