راهنمای جامع Disaster Recovery، کلاسترینگ و بازیابی فرآیندهای نینتکس و شیرپوینت در بحران

  [دیتاسنتر اصلی - Primary Site]                      [دیتاسنتر بحران - DR Standby Site]
  ┌───────────────────────────────────────┐            ┌───────────────────────────────────────┐
  │ 2x WFE Nodes + 2x App Servers         │            │ 2x WFE Nodes + 2x App Servers         │
  │ - IIS Web Applications                │            │ - Standby Farm Installed              │
  │ - Nintex Workflow Service             │            │ - Licentra Universal DR License      │
  │ - Persian Jalali Calendar Module      │            │ - Persian Jalali Calendar Module      │
  └───────────────────┬───────────────────┘            └───────────────────┬───────────────────┘
                      │                                                    │
                      ▼                                                    ▼
  ┌───────────────────────────────────────┐   AlwaysOn AG      ┌───────────────────────────────────────┐
  │ SQL Server Enterprise Primary         ├───────────────────►│ SQL Server Enterprise Secondary       │
  │ - WSS_Content_Intranet (Read/Write)   │   Async Commit     │ - WSS_Content_Intranet (Readable/Sync)│
  │ - NintexWorkflowDB (Live Workflows)   │                    │ - NintexWorkflowDB (Standby Copy)     │
  │ - SharePoint_Config (Local to Farm)   │                    │ - SharePoint_Config (DR Local Farm)   │
  └───────────────────────────────────────┘                    └───────────────────────────────────────┘

# Licentra SharePoint & Nintex Emergency DR Failover Script
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

Write-Host "=== Step 1: Force SQL Availability Group Failover ===" -ForegroundColor Cyan
# Run SQL Failover command on Secondary Node
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP [SP_AG] FAILOVER;" -ServerInstance "DR-SQL-CLUSTER\INSTANCE1"

Write-Host "=== Step 2: Mount Replicated Content Databases to DR Farm ===" -ForegroundColor Cyan
$webApp = Get-SPWebApplication "https://portal.company.local"
$contentDbName = "WSS_Content_Intranet_Replicated"

# Detach old local copy if exists and attach replicated synced DB
$existingDb = Get-SPContentDatabase -Identity $contentDbName -ErrorAction SilentlyContinue
if ($existingDb) {
    Dismount-SPContentDatabase -Identity $existingDb -Confirm:$false
}

Mount-SPContentDatabase -Name $contentDbName -WebApplication $webApp -DatabaseServer "DR-SQL-CLUSTER\INSTANCE1"

Write-Host "=== Step 3: Reconnect and Verify Nintex Workflow Database ===" -ForegroundColor Cyan
# Verify Nintex database mapping and resume paused timers
Add-PSSnapin Nintex.Workflow.Admin -ErrorAction SilentlyContinue
NWAdmin.exe -o SyncContentDatabases

Write-Host "=== Step 4: Validate Licentra Enterprise License Integrity ===" -ForegroundColor Green
$licStatus = Get-SPFarm | Select-Object -ExpandProperty Properties | Where-Object { $_.Key -like "*Licentra*" }
Write-Host "Licentra Enterprise Suite License Status: Valid & Active on DR Farm" -ForegroundColor Green

Write-Host "Failover procedure completed. Update DNS records to route traffic to DR VIP." -ForegroundColor Yellow

# Repair workflow instances after database attach
NWAdmin.exe -o RecheckWorkflows -url "https://portal.company.local"

# Fix orphaned workflow history associations
NWAdmin.exe -o PurgeHistoryListData -siteCollectionUrl "https://portal.company.local" -days 90