Reporting Services and Log Shipping

Hey All,
I setup a log shipped server so we could have a warm
backup but the only way I could make the business case to
spend the money was to use it as a reporting server as
well. Needless to say, people are not that happy about
getting kicked out all the time when the data is loading.
Is there anyway to mask the fact that the data source is
unavailable and just get reporting services to wait until
the load is done and resubmit the query when the
connection is available again.
Thanks,
BryanHave you looked into using execution snapshots. You could set the data to
only be refreshed when the data source is known to be available.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bmurtha" <anonymous@.discussions.microsoft.com> wrote in message
news:7ce501c47735$e821d580$a301280a@.phx.gbl...
> Hey All,
> I setup a log shipped server so we could have a warm
> backup but the only way I could make the business case to
> spend the money was to use it as a reporting server as
> well. Needless to say, people are not that happy about
> getting kicked out all the time when the data is loading.
> Is there anyway to mask the fact that the data source is
> unavailable and just get reporting services to wait until
> the load is done and resubmit the query when the
> connection is available again.
> Thanks,
> Bryan