Hi,
So I recently had to make some changes and wanted to ensure I could roll back, in the event of any issues.
Azure Storage is great at replication and availability but it doesn’t offer point in time restore, should you accidentally make some changes and want to roll back. So I wrote a quick little powershell script which uses AzCopy and the Table Storage Rest API to find all the tables in an account and then pull down a JSON file of their contents, tagged with the current time.
It uses a SAS token to limit the permissions the script has, only needing list & read, to minimize the risk if the script has an issue.
| param( | |
| [parameter(Mandatory=$true)] | |
| [string]$Account, | |
| [parameter(Mandatory=$true)] | |
| [string]$SASToken, | |
| [parameter(Mandatory=$true)] | |
| [string]$OutputDir | |
| ) | |
| $ErrorActionPreference = "Stop" | |
| ##Example Usage | |
| #.\Backup-TableStorage.ps1 -OutputDir "d:\tablebackup" -Account "examplestorageaccount" -SASToken "?sv=2015-04-05&ss=t&srt=sco&sp=rl&st=2016-04-08T07%3A44%3A00Z&se=2016-04-09T07%3A55%3A00Z&sig=CNotAREALSIGNITUREBUTYOURESWOUDLGOHERE3D" | |
| if (-not (Test-Path "${env:ProgramFiles(x86)}\Microsoft SDKs\Azure\AzCopy\AzCopy.exe")) | |
| { | |
| throw "Azcopy not installed – get it from here: https://azure.microsoft.com/en-gb/documentation/articles/storage-use-azcopy/" | |
| } | |
| Write-host "" | |
| Write-Host "Starting backup for account" -ForegroundColor Yellow | |
| Write-host "————————–" -ForegroundColor Yellow | |
| Write-Host " -Account: $Account" | |
| Write-Host " -Token: $SASToken" | |
| $response = Invoke-WebRequest -Uri "https://$Account.table.core.windows.net/Tables/$SASToken" | |
| [xml]$tables = $response.Content | |
| $tableNames = $tables.feed.entry.content.properties.TableName | |
| Write-host "" | |
| Write-host "Found Tables to backup" -ForegroundColor Yellow | |
| Write-host "————————–" -ForegroundColor Yellow | |
| foreach ($tableName in $tableNames) | |
| { | |
| Write-Host " -Table: $tableName" | |
| } | |
| foreach ($tableName in $tableNames) | |
| { | |
| $url = "https://$Account.table.core.windows.net/$tableName" | |
| Write-host "" | |
| Write-Host "Backing up Table: $url"-ForegroundColor Yellow | |
| Write-host "————————–" -ForegroundColor Yellow | |
| Write-host "" | |
| & "${env:ProgramFiles(x86)}\Microsoft SDKs\Azure\AzCopy\AzCopy.exe" /Source:$url /Dest:$OutputDir\$account\ /SourceSAS:$SASToken /Z:"$env:temp\$([guid]::NewGuid()).azcopyJournal" | |
| Write-host "" | |
| Write-host "Backup completed" -ForegroundColor Green | |
| Write-host "" | |
| Write-host "" | |
| } |
The only requirement for the script is AzCopy, an MS utility which it uses to pull down the content of each table.
(Here is a quick overview of SASTokens in Azure Storage, the Microsoft Storage Explorer offers a nice right click option to generate them – make sure you give the SASToken Permissions to access the Table Service, Read and List)
Hope it’s useful!
GripDev 