September 18, 2014 at 1:02 pm
We are using SCSM 2012 (Service Manager for Systems Center 2012) and our IT guy who handles Systems Center had to setup a new application server for Service manager last week and when he did this the process somehow deleted all of the custom reports we had created for the instance of SSRS we have running that is used by all parts of System Center.
If I load the SSRS Home Page I have 1 folder titled SystemsCenter. Within that folder are 2 folde4rs titled Operations Manager and Service Manager. Of these 2 folders everything within the Operations Manager is the same as before any of this happened. If I go into the ServiceManager folder I see 5 data Source items and no other folders or SSRS reports and there should be both folders and custom SSRS reports listed. The only thing I can figure is that when the IT guy told the new Service Manager app server where to look for the Reporting Services instance that Service Manage would use it must have reset everything within the ServiceManager folder since the items in the Operations Manage folder look to be unaltered. When I look at the ‘Date Modified’ Date/Time for the ServiceManager folder it shows 2014/09/11 3:23PM which is the same date and time of day when the IT guy wnet into the new Service Manager setup and pointed into the existing Reporting Services instance that Service Manager uses.
Q: I have restored a backup of the database ReportServer (as ReportServer_20140910) to the instance of SQL Server that the ReportServer DB is housed. Is there any way to take one or more items stored in the ReportServer_20140910 database and place them in the Report Server DB so that I can restore all my missing folders and SSRS reports?
I’m assuming that if I simply restore the ReportServer database as a whole from by backup from 2014/09/10 (the last backup of the ReportServer database done prior to the change the IT guy made) that I may break Service Manager in as far as its using SSRS. If however you think its OK to restore the ReportServer DB backup over top of the existing ReportServer DB then say so.
Any help is greatly appreciated as there are no backups of these custom reports other than the backup of the ReportServer DB which we presumed was a sufficient backup/recovery solution for these since we never imagined needing to restore single SSRS reports from backup.
Thanks
Kindest Regards,
Just say No to Facebook!September 18, 2014 at 2:33 pm
i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in the Report Server database, so it's reasonably easy to pull out copies, and then add them to a new project.
I've seen SSI, programs, and powershell scripts that all do it in one way or another.
search "export SSRS reports" or "migrate SSRS Reports"
I specifically used this project here, which did a nice job for me:
https://ssrscatalogqueries.codeplex.com/
so i would extrac tthem out, add them to a project, and then deploy them back to the new/updated server.
Lowell
September 18, 2014 at 3:57 pm
Lowell (9/18/2014)
i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in the Report Server database, so it's reasonably easy to pull out copies, and then add them to a new project.I've seen SSI, programs, and powershell scripts that all do it in one way or another.
search "export SSRS reports" or "migrate SSRS Reports"
I specifically used this project here, which did a nice job for me:
https://ssrscatalogqueries.codeplex.com/
so i would extrac tthem out, add them to a project, and then deploy them back to the new/updated server.
I have a query that converts the RDL from the binary format its stored in to plain text I just wasn’t sure how to then use it to put the report back. based on what your saying I should be able to say that as an rdl file and then open in a visual studio project (I assume an SSRS project) and then load it back into Reporting Services. I have to use SSRS because of some of the reporting needs here require it but I try to avoid it all costs (choosing Crystal Reports or any similar banded style report designer) because I so dislike how SSRS works. Initially I wanted very much to be a big fan and user of SSRS but once I got into it and found it was using an entirely different approach to report design that is IMHO (as a Crystal Reports developer with 10+_ years of experience in reporting) incredibly bad.
Thanks for the help
Kindest Regards,
Just say No to Facebook!Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply