Use PowerShell to Work with Analysis Service Database Backups

re: Use PowerShell to Work with Analysis Service Database Backups

NTornese — Thu, 20 Sep 2012 20:02:42 GMT

Nice script. Has worked well for me until today when I came across a database where the Name and ID didn't match. Here is how I fixed it:

Replaced this line: $DB=$server.databases.item($Database)

With this line: $DB=$server.databases.item($Database.ID)

re: Use PowerShell to Work with Analysis Service Database Backups

MAK — Tue, 31 May 2011 15:48:17 GMT

Klause! You are obsolutely right. I should have added statements like this at the end.

If ($? -eq $False)

{

Throw "Backup did not complete successfully"

EXIT

}

re: Use PowerShell to Work with Analysis Service Database Backups

MAK — Tue, 31 May 2011 15:48:17 GMT

Klause! You are obsolutely right. I should have added statements like this at the end.

If ($? -eq $False)

{

Throw "Backup did not complete successfully"

EXIT

}

re: Use PowerShell to Work with Analysis Service Database Backups

Klaus Schulte — Mon, 30 May 2011 08:06:12 GMT

Great article, the MAK!

Apart of the backup part it is a good example of error handling in the context of a backup task that fits into my "credo": Expect errors to happen!

kind regards, Klaus