SQL Server Performance Forum – Threads Archive
sql 2005 reporting services: User created reportswe 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.
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
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.