Solved

sql2005, how can I restore our reportserver db ?

Posted on 2012-03-13
1
353 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 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql calculate reminders 11 56
Help with SQL joins 9 37
Need help with a query 6 53
SQL Restore Script - Syntax Error 8 69
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now