sql 2005 reporting services: User created reports | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 2005 reporting services: User created reports

we are using sql 2005 RS. Our Users create lots of reports daily using report builder.
Could you explain how we can set up disaster recovery server so that all user created reports and templates are on disaster server too, I mean can we set up copy templates automatically or can we do it atleast manually ? I appreciate your help.
Thank you
I think you can take backup of report server database in this case, referhttp://blogs.msdn.com/swisowaty/attachment/661452.ashx link fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>