Post reply

Looking for information on SSRS Reports

  • July 29, 2015 at 10:22 pm

    #319417

    My SSRS reports are deployed on a server owned by a different team and now they are planning to upgrade their server. Should i manually take a copy of all reports and note down the schedules etc or should i take a backup of the reportserver db of that server and keep it?

  • July 29, 2015 at 10:33 pm

    #1815997

    If the reports are being developed using visual studio I would keep a copy of the solution/project and, yes, it would be a good idea to backup the reportserverdb. I would also backup the encryption key; see this article:

    https://msdn.microsoft.com/en-us/library/ms157275(v=sql.90).aspx

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • July 29, 2015 at 11:27 pm

    #1816002

    It would be much faster to backup the ReportServer database and the encryption key and then to restore those on the new server. The encryption key is critical to recover the subscriptions and schedules.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply