Hello Expert,

I'm planning to move scom reporting component to another server.  Will it affect the scheduled and favorite reports??

If yes, how to overcome this issue?  Is there anyway to backup Scheduled and Favorite reports and move to new reporting server?

Expecting your reply!!!

Regards

Karthick Malayalan 

Hi,

if you not move also both reporting server databases it will affect scheduled reports. I'm not sure what happens to favorite reports because I allways save my custom report to MP.

I have successfully done this migration two times so I can provide you some details. But I suggest that you first try this in test environment.

Regards,

Ivan

Hi Ivan,

Thanks for your quick response.

How to move the reporting server databases to new reporting server?  Could you please tell me in detail?

Regards

Karthick

Hi,

Hope the below articles be helpful for you:

How to Move the Data Warehouse Database

http://technet.microsoft.com/en-us/library/hh268492.aspx

Moving the Data Warehouse Database and Reporting server to new hardwaremy experience

http://blogs.technet.com/b/kevinholman/archive/2010/08/25/moving-the-data-warehouse-database-and-reporting-server-to-new-hardware-my-experience.aspx

My plan to move the Report Server to a new computer

http://blogs.technet.com/b/jonathanalmquist/archive/2011/01/21/my-plan-to-move-the-report-server-to-a-new-computer.aspx

Before moving the database, please do a database backup:

Create a Full Database Backup (SQL Server)

http://technet.microsoft.com/en-us/library/ms187510.aspx

Regards,

Yan Li

Hi Karthick,

I've been busy these days.

It is exactly as it is written by Jonathan Almquist. Look Yan's links. The key is step 6.

Regards,

Ivan 

To move reporting services to new server, you can refer below link

http://technet.microsoft.com/en-us/library/cc540369.aspx

@Ivan,

tonight I moved just my OperationsManagerDW database.

https://technet.microsoft.com/en-us/library/hh268492.aspx

I did not actually move any reporting services pieces. i can run reports, and my favorite reports are all still in the scom console. but when I click on Scheduled Reports, I get "The subscription '02444892-bea1-4922-8157-270713b75cbb' cannot be found. The subscription identifier that is provided to an operation cannot be located in the report server database."

any thoughts?

even weirder: my scheduled reports are still running on their schedules... i just can't view them in the scom console.

Hi Karthik,

Nice to see you here, I was facing the same issue where scheduled and custom/favorite reports not getting restored.

There is a great tool developed by Jasper Smith called Reporting Services Scripter. This tool is a .NET Windows forms application that can be used to script out and transfer all SQL Service Reporting Services catalog items.

https://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/

https://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

Sunil M