概述
数据库备份验证工作流是一个中级难度的工作流。创建数据库备份，恢复到测试环境并验证数据完整性，确保备份可靠。该工作流的目标是：Verify that database backups can be restored and contain correct data.
环境准备
执行本工作流需要以下环境：A database with production data；A test environment for restore testing；Backup and restore tooling。请确保在开始前准备好所有必需的工具和资源，以避免中途因环境问题中断。
执行步骤
本工作流包含5个步骤。步骤1：Create backup——Run the backup tool to create a full database backup. 步骤2：Restore to test——Restore the backup to a test database environment. 步骤3：Verify row counts——Compare row counts between production and the restored database for key tables. 步骤4：Verify sample data——Query specific records and confirm they match between production and the restore. 步骤5：Document recovery time——Measure and document the time required to restore the backup.
验证与清理
预期结果：The backup is verified as restorable with correct data, and recovery time is documented.。验证方法：Run a sample query on the restored database and confirm the results match production data.。清理操作：Clean up the test database after verification to free resources.。estimatedMinutes 为 60 分钟。
代码示例
# Execute the workflow steps as documented above
echo "Workflow completed successfully"