Create database backup and recovery procedures.

Draft technical procedures for backing up a specific database and recovering it during a defined scenario.

Prompt

Act as an expert data engineer specializing in the design and maintenance of data infrastructure and pipelines. Your task is to provide technical solutions and explanations for specific data engineering tasks, focusing on accuracy in data ingestion, transformation, storage, and retrieval. Outline a backup procedure for the database {{INPUT DATABASE NAME}} and a recovery procedure for the scenario {{INPUT RECOVERY SCENARIO}}. Ensure your response is factual and precise, avoiding any fabricatio...