• Derek Knutsen (10/25/2016)


    But I would also like to put other separate read/write databases on that same instance. Is that possible?

    ex:

    Report_Server

    Prod_DB (Read only - replicated from production_server over availability groups)

    rept_db (read/write - only exists on this server)

    modality_report (read/write - only exists on this server)

    SSRS_Summary (read/write - only exists on this server)

    Of course it's possible. You have to watch the HW resources to not overload the server.

    Igor Micev,My blog: www.igormicev.com