Post reply

How can I migrate SSRS subscriptions to a new server

  • July 29, 2016 at 2:48 pm

    #315752

    I am migrating to a new server, I moved the db and the reports moved, I update the datasources and SPs where needed. All this is running fine. Next step is to get the Subscriptions set back up.

    Any suggestions on getting them migrated over?

    I can see the subscriptions in the db, but they aren't on the report when I view them. Why would that be? something with the guids?

  • August 2, 2016 at 6:25 am

    #1893198

    Simply restoring the databases (make sure you restore both the Reporting Service and Reporting Server TempDB) on a different server will create the subscriptions on the new server, and you will be able to view these in the interface,

    If, however, you mean you can't see them in Agent, this is to be expected. The Subscription details themselves are held in the RS databases, but the jobs are in the msdb.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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