Binlabs

There are IT admins trying to take backup of configuration manager and all its reports along with custom one. There can be other scenarios where people may want to take the backup of Custom Reports.

Are you one of those looking for how to backup Custom Reports?

Please continue reading…

This can be achieved easily using PowerShell. Thanks to people who spent time to develop ReportingServicesTools.

All you need to do is:

1. Get the Name of Reporting Server.
2. Get the location folder where you want to task the backup.
3. PowerShell mentioned below.

#### Backup location must be added below. It can be local or shared. 
$BackupFolder = '\\BackupServer.binlabs.in\Reports backup\' 

#### SQL Server Reporting Server URL must be added below. 
$SSRSUri = 'http://SSRSSrv1.binlabs.in/ReportServer'

if((Get-Module ReportingServicesTools) -eq $null) 
{
    Install-Module -Name ReportingServicesTools -Force
}

try 
{
     $Source = New-RsWebServiceProxy -ReportServerUri $SSRSUri
Out-RsFolderContent -Proxy $Source  -path '/'  -Destination $BackupFolder -Recurse 
} 

catch 
{
    throw $_.Exception.Message     
} 

Special thanks to Ayushi Sabharwal, Neeraj Sarmai, Manish Kitey and Indrajit Maity for their contribution.

Hope this helps.

Happy Scripting!!!