tech2010
asked on
Copying ReportServer Database to another computer in SQL 2005
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
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
Take a backup of those databases , copy it to the new server and restore it on the new server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
well, it is not that easy that just backup and restore. If it was that then i could have already done this.
I am talking about ReportServer database which does not work just restoring. so please any other step by step intstructions?
I am talking about ReportServer database which does not work just restoring. so please any other step by step intstructions?