smsagent.blog
  • docs.smsagent.blog
  • Custom Reporting in Microsoft Intune
    • Delivery Optimization Report
    • Windows Update for Business Custom Reporting
      • Power BI Report Walkthrough
      • Known issues / limitations
      • Change log
      • Deploy the solution
        • Create Azure Resources
        • Configure Azure Resources
        • Deploy the client-side script
        • Deploy the Azure automation runbooks
        • Configure the Power BI report
      • Adding additional language support
      • Table schema reference
    • Automating Data Exports from Microsoft Graph
      • Azure Automation account
        • Create / configure an Azure automation account
        • Grant API permissions
        • Create an Azure automation runbook
      • Azure Storage account
      • Automate Data Export to Azure Storage Account
      • Automate Data Export to Azure Monitor Logs
      • Creating / Troubleshooting Runbooks
      • Power BI
        • Connect Power BI to an Azure storage account data source
        • Connect Power BI to an Azure log analytics workspace as a data source
    • Managed Devices Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a PowerBI report
      • MEM Managed Device Report template
      • Bonus! Unhealthy MEMCM Clients email report
    • Intune Assignments Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a Power BI report
      • Change log
    • Patch My PC Report
      • A look at the Power BI reports
      • Change log
      • Video guides
      • Things to know
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create the Power BI report
      • Feedback
    • Windows 11 Hardware Readiness Report
    • Gathering Custom Inventory with Intune
      • Set up the Azure Resources
      • Create a Proactive remediations script package
      • Create a runbook
  • PowerShell Scripts Online Help
    • Get-AzSubscriptionActivityLog
  • Azure Solutions
    • Automated Azure Table Storage Backups
      • Change log
      • Deploy the solution
        • Create the Azure resources
        • Set the backup schedule
        • Add storage tables to the backup
        • Add role assignments to the storage account/s
        • Create a lifecycle management rule
      • Run a manual backup
      • Restore a backup
Powered by GitBook
On this page

Was this helpful?

  1. Azure Solutions
  2. Automated Azure Table Storage Backups

Restore a backup

PreviousRun a manual backup

Last updated 1 year ago

Was this helpful?

To restore a backup, you can use the . This provides a nice UI to interface with the storage account and lets you import data from a CSV backup file into the target table, or into another table.

Using the Azure Storage Explorer, connect to your Azure subscription and locate the storage account containing your backups.

Within the tablebackups blob container, open the folder with your table name and identify which backup file you want to restore from.

Select the file and click Download in the menu to save the file locally.

Open the storage table you want to restore to and click Import in the menu.

Select your locally-saved backup file to import it.

Notice the option at the bottom: Replace entity values in the table with imported data. In my testing this option does not seem to have any effect as whether it is selected or not, any row being restored which matches the PartitionKey and RowKey of any entity in the table will be overwritten with the restored data.

In any case, any entities in the table in that are not present in the backup file will remain present in the table and any entities missing from the table will be restored from the imported data.

So if you want to do an authentic point-in-time restore, you may wish to first delete all the entities in the table before you restore, or simply restore to a new table, and change the name when you're happy that the restored data is good.

Microsoft Azure Storage Explorer