Video Script: Disaster Recovery for Azure Synapse¶

# Enable failover capability
$storageAccount = Get-AzStorageAccount `
    -ResourceGroupName "synapse-dr-rg" `
    -Name "synapsedr001"

# Initiate failover (only during actual disaster)
Invoke-AzStorageAccountFailover `
    -ResourceGroupName "synapse-dr-rg" `
    -Name "synapsedr001" `
    -Confirm:$false

# Verify failover status
Get-AzStorageAccount `
    -ResourceGroupName "synapse-dr-rg" `
    -Name "synapsedr001" |
    Select-Object PrimaryLocation, SecondaryLocation, StatusOfPrimary

# Get latest restore point
$restorePoints = Get-AzSqlDatabaseRestorePoint `
    -ResourceGroupName "synapse-primary-rg" `
    -ServerName "synapse-primary" `
    -DatabaseName "DW"

$latestRP = $restorePoints |
    Sort-Object RestorePointCreationDate -Descending |
    Select-Object -First 1

# Restore to secondary region
Restore-AzSqlDatabase `
    -FromPointInTimeBackup `
    -PointInTime $latestRP.RestorePointCreationDate `
    -ResourceGroupName "synapse-dr-rg" `
    -ServerName "synapse-dr" `
    -TargetDatabaseName "DW-DR" `
    -ResourceId $latestRP.ResourceId

# Export all workspace artifacts
$workspace = "synapse-primary"
$exportPath = "./backup/$(Get-Date -Format 'yyyy-MM-dd')"

New-Item -ItemType Directory -Path $exportPath -Force

# Export pipelines
$pipelines = Get-AzSynapsePipeline -WorkspaceName $workspace
foreach ($pipeline in $pipelines) {
    $pipeline | ConvertTo-Json -Depth 100 |
        Out-File "$exportPath/pipeline_$($pipeline.Name).json"
}

# Export notebooks
$notebooks = Get-AzSynapseNotebook -WorkspaceName $workspace
foreach ($notebook in $notebooks) {
    $notebook | ConvertTo-Json -Depth 100 |
        Out-File "$exportPath/notebook_$($notebook.Name).json"
}

# Export linked services
$linkedServices = Get-AzSynapseLinkedService -WorkspaceName $workspace
foreach ($ls in $linkedServices) {
    $ls | ConvertTo-Json -Depth 100 |
        Out-File "$exportPath/linkedservice_$($ls.Name).json"
}

# scheduled-backup.ps1
param(
    [string]$WorkspaceName,
    [string]$StorageAccount,
    [string]$Container = "workspace-backups"
)

$date = Get-Date -Format "yyyy-MM-dd-HHmmss"
$tempPath = "./temp-backup"
$zipPath = "./backup-$date.zip"

# Export artifacts
New-Item -ItemType Directory -Path $tempPath -Force

# ... export logic from previous example ...

# Create archive
Compress-Archive -Path $tempPath -DestinationPath $zipPath

# Upload to storage
$ctx = New-AzStorageContext -StorageAccountName $StorageAccount -UseConnectedAccount

Set-AzStorageBlobContent `
    -File $zipPath `
    -Container $Container `
    -Blob "backups/backup-$date.zip" `
    -Context $ctx

# Cleanup
Remove-Item $tempPath -Recurse -Force
Remove-Item $zipPath -Force

Write-Host "Backup completed: backup-$date.zip"

# failover.ps1
param(
    [string]$PrimaryWorkspace,
    [string]$SecondaryWorkspace,
    [string]$PrimaryRegion = "eastus2",
    [string]$SecondaryRegion = "westus2"
)

Write-Host "Initiating failover from $PrimaryRegion to $SecondaryRegion"

# 1. Pause primary SQL pool
Write-Host "Pausing primary SQL pool..."
Suspend-AzSynapseSqlPool `
    -WorkspaceName $PrimaryWorkspace `
    -Name "DW"

# 2. Failover storage account
Write-Host "Initiating storage failover..."
Invoke-AzStorageAccountFailover `
    -ResourceGroupName "synapse-primary-rg" `
    -Name "synapseprimary001"

# 3. Update DNS/Traffic Manager
Write-Host "Updating Traffic Manager..."
$endpoint = Get-AzTrafficManagerEndpoint `
    -ResourceGroupName "synapse-rg" `
    -ProfileName "synapse-tm" `
    -Name "secondary-endpoint" `
    -Type AzureEndpoints

$endpoint.EndpointStatus = "Enabled"
Set-AzTrafficManagerEndpoint -TrafficManagerEndpoint $endpoint

# 4. Resume secondary SQL pool
Write-Host "Resuming secondary SQL pool..."
Resume-AzSynapseSqlPool `
    -WorkspaceName $SecondaryWorkspace `
    -Name "DW"

# 5. Validate
Write-Host "Validating failover..."
$health = Test-SynapseHealth -Workspace $SecondaryWorkspace

if ($health.Status -eq "Healthy") {
    Write-Host "Failover completed successfully!" -ForegroundColor Green
} else {
    Write-Host "Failover validation failed!" -ForegroundColor Red
    Write-Host $health.Details
}

# failback.ps1
param(
    [string]$PrimaryWorkspace,
    [string]$SecondaryWorkspace
)

Write-Host "Initiating failback to primary region"

# 1. Sync data from secondary to primary
Write-Host "Syncing data..."
& azcopy sync `
    "https://synapsesecondary.dfs.core.windows.net/" `
    "https://synapseprimary.dfs.core.windows.net/" `
    --recursive

# 2. Restore SQL pool from latest geo-backup
Write-Host "Restoring primary SQL pool..."
Restore-AzSqlDatabase `
    -FromGeoBackup `
    -ResourceGroupName "synapse-primary-rg" `
    -ServerName "synapse-primary" `
    -TargetDatabaseName "DW" `
    -ResourceId $geoBackup.ResourceId

# 3. Switch traffic back
Write-Host "Switching traffic to primary..."
# Update Traffic Manager or DNS

# 4. Pause secondary
Write-Host "Pausing secondary SQL pool..."
Suspend-AzSynapseSqlPool `
    -WorkspaceName $SecondaryWorkspace `
    -Name "DW"

Write-Host "Failback completed!"

# dr-test.ps1
Write-Host "Starting DR Test..."

$startTime = Get-Date

# Clone secondary to test environment
$testWorkspace = New-AzSynapseWorkspace `
    -ResourceGroupName "synapse-test-rg" `
    -Name "synapse-dr-test" `
    -Location "westus2" `
    -DefaultDataLakeStorageAccountName "testdatalake" `
    -DefaultDataLakeStorageFilesystem "test"

# Measure RTO
$rto = (Get-Date) - $startTime
Write-Host "RTO: $($rto.TotalMinutes) minutes"

# Cleanup
Remove-AzSynapseWorkspace -Name "synapse-dr-test" -Force