Help Center/ Data Replication Service/ Troubleshooting/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Uses the Full Recovery Model
Updated on 2025-07-21 GMT+08:00
View PDF

Checking Whether the Source Database Uses the Full Recovery Model

Check whether the source database uses the full recovery model.

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