Configure Weekly Backup for Azure SQL Database | AZ-500 Exam Preparation

Configure Weekly Backup of Azure SQL Database - Homepage

Question

SIMULATION -

You need to configure a weekly backup of an Azure SQL database named Homepage. The backup must be retained for eight weeks.

To complete this task, sign in to the Azure portal.

Explanations

See the explanation below.

You need to configure the backup policy for the Azure SQL database.

1. In the Azure portal, type Azure SQL Database in the search box, select Azure SQL Database from the search results then select Homepage. Alternatively, browse to Azure SQL Database in the left navigation pane.

2. Select the server hosting the Homepage database and click on Manage backups.

3. Click on Configure policies.

4. Ensure that the Weekly Backups option is ticked.

5. Configure the How long would you like weekly backups to be retained option to 8 weeks.

6. Click Apply to save the changes.

Sure, here's a step-by-step guide on how to configure a weekly backup of an Azure SQL database named Homepage and retain it for eight weeks:

  1. Sign in to the Azure portal (https://portal.azure.com/).
  2. Navigate to the Homepage SQL database.
  3. On the left-hand side, click on the "Backup" option under the "Settings" section.
  4. Click on the "Configure Backup" button.
  5. In the "Backup policy details" section, select "Weekly" from the "Backup frequency" dropdown menu.
  6. Set the backup time to your desired time by adjusting the "Backup start time" and "Backup retention period" options.
  7. In the "Retention" section, select the "Point in time restore" option and set it to "8 weeks."
  8. Click the "Save" button to save the backup policy.

That's it! You have now configured a weekly backup of your Azure SQL database named Homepage and set the retention period to eight weeks. The backup will automatically run at the scheduled time and the retention period will ensure that you can restore the database to any point within the past eight weeks.