Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Copying ReportServer Database to another computer in SQL 2005

Posted on 2009-05-08
3
Medium Priority
?
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

618 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