1. aggalak New Member

   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

   aggalak, Jul 30, 2006

   #2
2. satya Moderator

   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.

   satya, Aug 1, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in