Post reply

Replication of SSRS2008 to a DR site

  • June 16, 2009 at 6:04 pm

    #201496

    This might be a simple question with a simple answer. I hope so 🙂 I'm "just a developer".

    We have an application that uses some reports that are hosted at our main office site on a report server. We are putting a DR plan in place. What I am wondering is what would be involved in replicating this environment into our DR environment? Is it as simple as replicating the ReportServer database and ensuring that the environment is configured properly or is it more complicated than that?

    Your advice and voices of experience would be much appreciated.

  • July 12, 2009 at 10:43 pm

    #1023670

    Anyone?

  • July 18, 2009 at 12:44 pm

    #1026599

    This is the Microsoft guide for migrating SSRS from one server to another which is similar to DR so you need to have at least ReportServerDb, ReportServerTempDB and your datasource DB or DBs because without these you are looking at fresh install which is not DR.

    http://technet.microsoft.com/en-us/library/ms143724(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • July 18, 2009 at 1:44 pm

    #1026603

    Awesome. Thanks for that. Much appreciated.

    Michelle

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

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