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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.