This article details how to configure FocalScope's reporting module to pull data from a shadow backup copy of the FocalScope database.
You can download a PDF version of this article and the stand-alone diagram in the attachments section at the end of this article.
Please note, two SQL servers need to be used for the configuration:
Conditions to be mindful of in this configuration:
SQL server & databases layout (2 SQL servers, 2 databases):
Figure 1 - Report cache resides in main database