May 11, 2009 at 12:50 am
I have a lot of rdl files installed under different folders in report server. I want to backup only few folders out of them & not the complete report server. The problem with taking full report server backup is, when I restore the reportserver, it overwrites all the other folders present in the report server.
The .rdls are not created with the help of SQL Server Business Intelligence Development studio. These are created with the help of a feature provided in the product we are using. I am using Microsoft SQL Server 2005.
I will take an example to explain you better:
When I connect to reporting server through SQL server management studio, I see a Home folder. Under this folder, I've created 3 folders viz. A,B and C. In each of these 3 folders, I've created 2 rdl files each say A1,A2,B1,B2,C1,C2. Now, If I take the backup of whole report server and restore it at some other place, It will create 3 folders A,B,C and underlying rdl files. But, I want to backup folder A only. Is it possible? How I can backup rdl files inside along with their snapshot history?
Let me know if anyone was able to resolve this issue. Hoping for your help
Thanks,
Ajit
May 12, 2009 at 11:04 am
SSRS db's behave just like regular db's you cannot backup just one report you have to backup the whole database.
Backup and Restore Operations for a Reporting Services Installation
http://msdn.microsoft.com/en-us/library/ms155814(SQL.90).aspx
Moving a Report Server Database to Another Computer
http://technet.microsoft.com/en-us/library/ms156421(SQL.90).aspx
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply