Report Portal

Automated backups using PowerShell and the SQL Server Agent

One of the least known features of SQL Server 2012 is the addition of several PowerShell cmdlets for managing Analysis Services servers. See my previous blog post on using PowerShell cmdlets for managing tabular models for more information. When I was fiddling with the SQL Server Agent recently, I noticed that the Agent can execute PowerShell scripts automatically. Just for fun, let's put these two things together and create a basic SQL Agent job that automatically backs up an Analysis Services database using PowerShell.


Tags: amo, backup, script, powershell


2007-2015 VidasSoft Systems Inc.