• Great job Dave, well done.

    The automation of the process and use of proxies is a nice touch.

    There is nowhere near enough information on SSRS DR out there and this is a much needed addition.

    Its worth pointing out the reporting databases will need to be in full recovery mode to use mirroring, and in fact any HA solution could be used to get the database to the failover server,be it full copy and restores, log shipping or even SAN replication.

    ---------------------------------------------------------------------