Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


sql server 2005 reporting services backup

Posted on 2007-10-18
Medium Priority
Last Modified: 2008-01-09
to backup my reporting services database would i just need to backup ReportServer, or does ReportServerTempDB also need backedup
Question by:Fraser_Admin
  • 3
  • 2
LVL 20

Expert Comment

ID: 20100132
ReportServerTempDB stores report cache information. When a report is set as a cached instance, there is no definite time when that report is executed. It depends on which process requests the report first. Once the report is executed, the intermediate format and data are stored in the ReportServerTempDB database. If this database were to fail, the cached information would be lost. But, since it is executed when a user views the report, there is no real loss of information.
LVL 20

Assisted Solution

Sirees earned 2000 total points
ID: 20100141
According to BOL "Backup and Restore Operations for a Reporting Services Installation"

The only reason to backup the reportservertempdb is to avoid having to
recreate it if there is a hardware failure.

Author Comment

ID: 20100158
why am i unable to backup the log file for reportserver in a maintenance plan.  usually it gives me the optoin to backup full, differential or log.  but for this database only full or differential. do log files grow in the db like other ones?

i'm just concerned of loosing subscription information since i have over 100 reports auto emailed.  don't feel like going threw a bunch of email to set it up again.
LVL 20

Accepted Solution

Sirees earned 2000 total points
ID: 20100306
<<why am i unable to backup the log file for reportserver >>

Check the recovery model. If it is set to Simple you cannot take log backups. To take Transaction log backups it should be set to full.

Author Comment

ID: 20101634
oh i bet that is it....thanks

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
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.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

564 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