In this recipe, we will create an SSAS database backup.
Choose an SSAS database you want to back up, and replace the –Name
parameter in the recipe. Ensure that you are running PowerShell with administrator privileges to the SSAS instance.
These are the steps required to create an SSAS database backup:
Open PowerShell ISE as an administrator.
Import the
SQLASCmdlets
module as follows:#import SQLASCmdlets module Import-Module SQLASCmdlets -DisableNameChecking
Add the following script and run it:
$instanceName = "localhost" $backupfile = "C:\Temp\AWDW.abf" Backup-ASDatabase -BackupFile $backupfile -Name "AWDW" -Server $instanceName -AllowOverwrite -ApplyCompression