• Sue_H - Friday, April 21, 2017 4:07 PM

    Thank you very much Sue,
    I really appreciate your advice,
    Giovanni

    You probably don't want to think about mirroring for that upgrade since it is going away - the replacement being always on availability groups.
    In terms of staying with mirroring - no it won't work with SSRS. The biggest issue being that only user databases can be mirrored.
    If your main concern is just with reporting interfering with other activities on a database server, you could install SSRS on it's own server. It doesn't need to be on the same server as other user databases. If it's used heavily, you'd probably want to use two servers - one for the databases and the other for the Services.
    If availability is a concern, going to always on availability groups in 2016 would be better than mirroring. The requirements, issues, behaviors in this environment are documented in this Microsoft article:
    Reporting Services with Always On Availability Groups (SQL Server)

    Sue