Solved

Copying ReportServer Database to another computer in SQL 2005

Posted on 2009-05-08
3
462 Views
Last Modified: 2012-05-06
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
Comment
Question by:tech2010
  • 2
3 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24338022
Take a backup of those databases , copy it to the new server and restore it on the new server
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24338039
0
 

Author Comment

by:tech2010
ID: 24341261
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

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question