Help Center/ Cloud Backup and Recovery/ Best Practices/ Using a Custom Script to Implement Application-Consistent Backup/ Verifying the Application-Consistent Backup Result
Updated on 2024-08-28 GMT+08:00
View PDF
Share

Verifying the Application-Consistent Backup Result

After application-consistent backup is implemented using customized scripts, perform the following operations to check whether the backup is successful:

Verifying the Application-Consistent Backup Result (Linux)

The following uses the MySQL database as an example.

  1. Log in to MySQL database and create a database.
  2. After the database is created, create a stored procedure. For details, see Figure 1.

    Figure 1 Creating a stored procedure

  3. Log in to the CBR console and create an application-consistent backup for the desired ECS.
  4. After the backup is complete, open the /home/rdadmin/Agent/log/thirdparty.log file and view the freezing and unfreezing logs to determine the freezing and unfreezing times.
  5. 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.
  6. 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.

Verifying the Application-Consistent Backup Result (Windows)

The following uses the SQL Server database as an example.

  1. Log in to SQL Server database and create a database.
  2. After the database is created, create a stored procedure. For details, see Figure 2.

    Figure 2 Creating a stored procedure

  3. Log in to the CBR console and create an application-consistent backup for the desired ECS.
  4. 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 3 Viewing logs

  5. 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).
  6. 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.
Parent Topic: Using a Custom Script to Implement Application-Consistent Backup