Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sql2005, how can I restore our reportserver db ?

Posted on 2012-03-13
1
Medium Priority
?
383 Views
Last Modified: 2012-03-15
we have problem with our ssrs reportserverdb and thinking restoration of previous report might be help us , anyone know the step how to perform the restore for reportserver db thus having the same contain, or pure restore will works ?

Or do I need to create new reportserverdb vis SSRS config mgmt tool, then I heard using rs utility can do to extract data from old report db then deploy to this newly create, if yes anyone can provide the steps?
0
Comment
Question by:motioneye
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 37722457
do you have the fresh reportserver DB backup?
if you do
How to: Restore a Database Backup (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms177429.aspx
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

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…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

926 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