Help Center/
Cloud Backup and Recovery/
Best Practices (Paris)/
Using a Custom Script to Implement Application-Consistent Backup/
Verifying the Application-Consistent Backup Result (Windows)
Updated on 2024-03-27 GMT+08:00
Verifying the Application-Consistent Backup Result (Windows)
After application-consistent backup is implemented using customized scripts, perform the following operations to check whether the backup is successful: This section uses the SQL_SERVER database as an example.
Procedure
- Log in to SQL_SERVER database and create a database.
- After the database is created, create a stored procedure. For details, see Figure 1.
- Log in to the CBR console and create an application-consistent backup for the desired ECS.
- After the backup is complete, open the Cloud Server Backup Agent-WIN64\log\ rdagent.txt file and view the freezing and unfreezing logs to determine the freezing and unfreezing times. As shown in the figure, the freeze success time is 17:28:51.
Figure 2 Viewing logs
- Use the newly created application-consistent backup to restore the ECS. After the restoration is successful, log in to the ECS and database and check the time when the last data record is inserted (17:28:49 in the following figure).
- Compare the VSS freezing success time recorded in step 5 with the time recorded in step 4. Before the freezing is successful, data insertion is stopped. Therefore, the time in step 5 should be earlier than that in step 4. If the time in step 5 is earlier than that in step 4, the application-consistent backup is successful.
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.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot