PowerShell.com
Library » Script Library » SQL Server » Backup-SSAS

Backup-SSAS

Previous | Next | View all files | View Slideshow
posted by Richard Giles
10-06-2008
Downloads: 731
File size: 5.8kB
Views: 4,762
Embed
Backup-SSAS
  1. ## ===================================================================== 
  2. ## Title       : Backup-SSAS 
  3. ## Description : Backup all Analysis Server databases 
  4. ## Author      : Idera 
  5. ## Date        : 6/27/2008 
  6. ## Input       : -serverInstance <server\inst> 
  7. ##               -backupDestination <drive:\x\y | \\unc\path> 
  8. ##               -retentionDays <n> 
  9. ##               -logDir <drive:\x\y | \\unc\path> 
  10. ##               -verbose  
  11. ##               -debug     
  12. ## Output      : write backup files (*.abf) 
  13. ##                   create log file of activity 
  14. ## Usage            : PS> . Backup-SSAS -serverInstance MyServer -Destination C:\SSASbackup  
  15. ##                                 -RetentionDays 2 -LogDir C:\SSASLog -v -d 
  16. ## Notes            : Original script attributed to Ron Klimaszewski 
  17. ## Tag            : Microsoft Analysis Server, SSAS, backup 
  18. ## Change Log  : 
  19. ## ===================================================================== 
  20.  
  21. param  
  22. (  
  23.     [string]$ServerInstance = "(local)",  
  24.     [string]$BackupDestination,  
  25.     [int]$RententionDays = 2,  
  26.     [string]$LogDir,  
  27.     [switch]$verbose, 
  28.     [switch]$debug 
  29. ) 
  30.  
  31. function main() 
  32. { 
  33.     if ($verbose) {$VerbosePreference = "Continue"} 
  34.     if ($debug) {$DebugPreference = "Continue"} 
  35.     Backup-SSAS $serverInstance $backupDestination $retentionDays $logDir 
  36. } 
  37.  
  38. function Backup-SSAS($serverInstance, $backupDestination, $retentionDays, $logDir) 
  39. { 
  40.     trap [Exception]  
  41.     { 
  42.         write-error $("TRAPPED: " + $_.Exception.Message); 
  43.         continue; 
  44.     } 
  45.      
  46.     # Force a minimum of two days of retention  
  47.     # TIP: using PS "less than" operator 
  48.     if ($RetentionDays -lt 2 )  
  49.     { 
  50.         $RetentionDays = 2  
  51.     }  
  52.      
  53.     # Load Microsoft Analysis Services assembly, output error messages to null 
  54.     [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null 
  55.      
  56.     # Declare SSAS objects with strongly typed variables 
  57.     [Microsoft.AnalysisServices.Server]$SSASserver = New-Object ([Microsoft.AnalysisServices.Server])  
  58.     [Microsoft.AnalysisServices.BackupInfo]$serverBackup = New-Object ([Microsoft.AnalysisServices.BackupInfo])  
  59.      
  60.     # Connect to Analysis Server with specified instance 
  61.     $SSASserver.Connect($ServerInstance)  
  62.      
  63.     # Set Backup destination to Analysis Server default if not supplied 
  64.     # TIP: using PowerShell "equal" operator 
  65.     if ($backupDestination -eq "")  
  66.     { 
  67.         Write-Debug "Setting the Destination parameter to the BackupDir parameter"  
  68.         $BackupDestination = $SSASserver.ServerProperties.Item("BackupDir").Value  
  69.     }  
  70.      
  71.     # Test for existence of Backup Destination path 
  72.     # TIP: using PowerShell ! operator is equivalent to "-not" operator, see below 
  73.     if (!(test-path $backupDestination))  
  74.     { 
  75.         Write-Host Destination path `"$backupDestination`" does not exists.  Exiting script.  
  76.         exit 1  
  77.     }  
  78.     else  
  79.     { 
  80.         Write-Host Backup files will be written to `"$backupDestination`"  
  81.     }  
  82.      
  83.     # Set Log directory to Analysis Server default if not applied 
  84.     if ($logDir -eq "")  
  85.     { 
  86.         Write-Debug "Setting the Log directory parameter to the LogDir parameter"  
  87.         $logDir = $SSASserver.ServerProperties.Item("LogDir").Value  
  88.     }  
  89.      
  90.     # Test for existence of Log directory path 
  91.     if (!(test-path $logDir))  
  92.     { 
  93.         Write-Host Log directory `"$logDir`" does not exists.  Exiting script.  
  94.         exit 1  
  95.     }  
  96.     else  
  97.     { 
  98.         Write-host Logs will be written to $logDir  
  99.     }  
  100.      
  101.     # Test if Log directory and Backup destination paths end on "\" and add if missing 
  102.     # TIP: using PowerShell "+=" operator to do a quick string append operation 
  103.     if (-not $logDir.EndsWith("\"))  
  104.     { 
  105.         $logDir += "\" 
  106.     }  
  107.      
  108.     if (-not $backupDestination.EndsWith("\"))  
  109.     { 
  110.         $backupDestination += "\" 
  111.     }  
  112.      
  113.     # Create Log file name using Server instance 
  114.     [string]$logFile = $logDir + "SSASBackup." + $serverInstance.Replace("\","_") + ".log"  
  115.     Write-Debug "Log file name is $logFile" 
  116.      
  117.     Write-Debug "Creating database object and set options..." 
  118.     $dbs = $SSASserver.Databases  
  119.     $serverBackup.AllowOverwrite = 1  
  120.     $serverBackup.ApplyCompression = 1  
  121.     $serverBackup.BackupRemotePartitions = 1  
  122.      
  123.     # Create backup timestamp 
  124.     # TIP: using PowerShell Get-Date to format a datetime string 
  125.     [string]$backupTS = Get-Date -Format "yyyy-MM-ddTHHmm"  
  126.      
  127.     # Add message to backup Log file 
  128.     # TIP: using PowerShell to output strings to a file 
  129.     Write-Debug "Backing up files on $serverInstance at $backupTS" 
  130.     "Backing up files on $ServerInstance at $backupTS" | Out-File -filepath $LogFile -encoding oem -append  
  131.      
  132.     # Back up the SSAS databases 
  133.     # TIP: using PowerShell foreach loop to enumerate a parent-child object 
  134.     foreach ($db in $dbs)  
  135.     { 
  136.         $serverBackup.file = $backupDestination + $db.name + "." + $backupTS + ".abf"  
  137.      
  138.         # TIP: using mixed string literals and variable in a Write-Host command 
  139.         Write-Host Backing up $db.Name to $serverBackup.File  
  140.         $db.Backup($serverBackup)  
  141.          
  142.         if ($?) {"Successfully backed up " + $db.Name + " to " + $serverBackup.File | Out-File -filepath $logFile -encoding oem -append}  
  143.         else {"Failed to back up " + $db.Name + " to " + $serverBackup.File | Out-File -filepath $logFile -encoding oem -append}  
  144.     }  
  145.      
  146.     # Disconnect from Analysis Server 
  147.     $SSASserver.Disconnect()  
  148.      
  149.     # Clear out the old files and files backed up to the Log file 
  150.     Write-Host Clearing out old files from $BackupDestination  
  151.     [int]$retentionHours = $retentionDays * 24 * - 1  
  152.     "Deleting old backup files" | Out-File -filepath $logFile -encoding oem -append  
  153.      
  154.     # TIP: using PowerShell get-childitem (get child items for matching location) and pipe to 
  155.     #        where-object (selecting certain ones based on a condition)  
  156.     get-childitem ($backupDestination + "*.abf") | where-object {$_.LastWriteTime -le [System.DateTime]::Now.AddHours($RetentionHours)} | Out-File -filepath $logFile -encoding oem -append  
  157.     get-childitem ($backupDestination + "*.abf") | where-object {$_.LastWriteTime -le [System.DateTime]::Now.AddHours($RetentionHours)} | remove-item  
  158. } 
  159.  
  160. main 
Filed under: ,

Back up all Microsoft Analysis Server databases

Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.