April 21, 2014 at 9:24 am
Hi,
I have looked around and it doesn't seem possible, at least through a GUI but I'm going to ask anyway. We have a bulk of reports, some have subscriptions that we would like to put on a DR server. The problem with restoring the whole reportserver database is that it will restore everything and also once the restore completes we don't want the subscriptions to send emails out. I don't really want to disable the agent to prevent this because the agent is running multiple jobs. The scripter tool I found way back I was never able to get working, and now I can't find it anyway. I found a report migration tool by microsoft but was unable to figure this tool out. http://www.microsoft.com/en-us/download/details.aspx?id=29560
Does anyone know if this can be done? Thanks for any help.
April 21, 2014 at 2:26 pm
Not sure I understand. You want to move subscriptions but you don't want to use the subscriptions? If you don't want to use the subscriptions why move them in the first place?
You could just disable the SQL Server Agent jobs for SSRS subscriptions.
What is the goal of this? Testing? Disaster Recovery? High availability?
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply