Help Center/ Cloud Backup and Recovery/ Best Practices (ME-Abu Dhabi Region)/ Using a Custom Script to Implement Application-Consistent Backup/ Verifying the Application-Consistent Backup Result (Windows)
Updated on 2022-02-22 GMT+08:00
View PDF
Share

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

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

    Figure 1 Creating a stored procedure

  3. Log in to 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 2 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.