Our reports are connecting to a database snapshot for their data. Periodically this snapshot loads, which means for a minute or two the reports go down. There is however another snapshot available, and between the two one will always be up. Is there a way with Reporting Services to dynamically switch between the two, depending on which one is up? These snapshots are on a constant schedule, so it would also acceptible (but not as nice), to have the database connection automatically switch at certain times of the day.
These snapshots are on the same server, or I would try using a failover partner in the connection string. To the best of my knowledge, this only switches servers, not the database instances.
No, there's no such feature. You could do this with a linked report, each which uses a snapshot which is generated on a different schedule. -- Then, your app could decide which one should be served based on when a user requests it. You'll always have one which is "ready" that way.
No comments:
Post a Comment