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 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.