Copying ReportServer Database to another computer in SQL 2005
Posted on 2009-05-08
We have got live working SQL 2005 reporting server. We build another Reporting server SQL 2005 on the new hardware, and we want to copy ReportServer, ReportServerTempDB copy from live to the new hardware so that we can do testing on the new hardware.
Once test completed we will do another data refresh and eventually new hardware will become live. So please tell me steps how can i restore/copy ReportServer and ReportServerTempDB across. Thanks