• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

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
0
tech2010
Asked:
tech2010
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Take a backup of those databases , copy it to the new server and restore it on the new server
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
tech2010Author Commented:
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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now