Hello! I want to restore production report Server to test environment. It is for SSRS 2005. Can someone please explain best practices for doing so? Shall I restore both Report Server and ReportServer TempDB on test server OR only Report Server? My aim is to get a copy of prod server on test. If you need more information, please let me know. Thanks!

Hi, Please refer this thread. A similar type of issue has been discussed. RegardsPlease click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi, Please refer this thread. A similar type of issue has been discussed. RegardsPlease click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

I used following link for restoring Reporting server database. http://msdn.microsoft.com/en-us/library/ms157275.aspx

I used following link for restoring Reporting server database. http://msdn.microsoft.com/en-us/library/ms157275.aspx