troubleshooting Question

How to confirm SSRS Subscriptions are good after restoring ReportServer to another database

Avatar of dbaSQL
dbaSQLFlag for United States of America asked on
Microsoft SQL ServerSSRSMicrosoft Server OS
9 Comments1 Solution219 ViewsLast Modified:
ReportServer Subscriptions -- We migrated ReportServer to ReportServerNEW with a simple backup/restore -- on the SAME server.  When we restored ReportServerNEW, we also used the encryption key from the source ReportServer instance, and all reports are accessible now in the new SSRS instance, Report Manager.  

But -- what about the subscriptions?  How do I know they are good?  They may be fine, because I used the steps outlined here for the move:
   https://docs.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-2017

WHERE it says:    "Subscriptions, cached reports, and snapshots are preserved in the moved database. If a snapshot is not picking up refreshed data after the database is moved, clear the snapshot options in Report Manager, click Apply to save your changes, re-create the schedule, and click Apply again to save your changes."

I just don't know how to confirm.  What is the right way to confirm that the subscriptions are all scheduled/enabled/on in the new instance, after migrating the ReportServer database?
ASKER CERTIFIED SOLUTION
EugeneZ
SQL SERVER EXPERT

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 9 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 9 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004