Checking Whether the Source Database Uses the Full Recovery Model
Microsoft SQL Server as the Source in Synchronization
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot