sql server 2005 reporting services backup

Posted on 2007-10-18
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
    LVL 20

    Expert Comment

    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

    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

    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

    <<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

    oh i bet that is it....thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 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