Home Forums SQL Server 2008 SQL Server 2008 - General What, if any, is the best type of replication for implementing on hundreds of databases on one server? RE: What, if any, is the best type of replication for implementing on hundreds of databases on one server?

  • February 22, 2013 at 6:10 am

    #1590314

    tomes12 (2/22/2013)

    Do you have any ideas how to test/calculate/analyze this before-hand?,

    I can't think of a way (other than creating a dedicated log shipping/mirroring test environment and using copies of your production DB's within that environment) that you'd be able to test or analyse the impact of the solution.

    Does anyone have any other thoughts?

    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk