Posts

Showing posts from December, 2024

SSAS Cube or Database backup with Powershell command "Backup-AsDatabase"

Image
#Date Converion with minutes and seconds $date = ( get-date ).ToString( "MM_dd_yyyy_hh_mm_ss" ) $Server = New-Object Microsoft.AnalysisServices.Server $Server .Connect( "MAPS\TEST" ) $dbservers = $Server .Databases| Select-Object Name,ParentServer $dbservers | ForEach -Object{ $inddb = $_ #The "Backup-AsDatabase" is especially for SSAS cube backup and downloaded from "SQLServer" powershell module Backup-ASDatabase -BackupFile "E:\MAPS_TEST\SSAS_BACKUP\NEW\ $( $ inddb.Name) _ $( $ date) .abf" -Name $inddb .Name -Verbose -Server $inddb .ParentServer Write-Host "SSAS cube backup [ $( $ inddb.Name) ] completed successfully on server [ $( $ inddb.ParentServer) ]" Write-Output "SSAS cube backup [ $( $ inddb.Name) ] completed successfully on server [ $( $ inddb.ParentServer) ]" }