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 8:56 am

    #1590402

    Oliiii (2/22/2013)

    We've tried mirroring many DB on the same instance and we started having problem at around 50 DBs, that might have changed on SQL 2012 though but mirroring is not designed for that kind of things.

    @ Oliiiii - What problems did you come up against when you hit 50 DB's, I have heard that MS recommend no more than 10 databases on a 32bit system as well - is that you're experience?

    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