#Objective: To backup database on the given Analysis Server 
#Created by: MAK
#Create Date: 9/9/2007

param
([string] $Servername, [string] $databasename, [string] $location, [switch] $compress, [string] $password)

[string] $mydate=date
$mydate=$mydate.replace(":"," ")
$mydate=$mydate.replace("/"," ")
$mydate="_" +$mydate.replace(" ","_")

$filename=$location+ $databasename +$mydate+ ".abf"


## Add the AMO namespace
[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") >$NULL

$server = New-Object Microsoft.AnalysisServices.Server
$server.connect($ServerName) 

if ($server.name -eq $null) {
 Write-Output ("Server '{0}' not found" -f $ServerName)
 break
}
else
{
$dbstring=$server.Databases |select-object name| select-string -simplematch $databasename

if ($dbstring)
{

if ($compress)
{$compression=$True
}
else
{
$compression=$False
}

$db=$server.databases.item($databasename)
$db.backup($filename,$True,$True,$NULL,$compression,$password)
write-host "Backup File name is " $filename
}
else
{
 Write-host "Database " $databasename " does not exist on the server $Servername"
 break

}

}