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?

  • Hi, thanks for the quick response.

    Of course, I see what you're saying.

    Yes, mirroring/log shipping is all an option and under consideration.

    That still asks the question how would it work if I enable it for 500 databases?

    How much additional load would it create? How much bandwidth would it take up?

    I've done tons of DR solutions in the past, but never on this scale, and I can't just start ramping up log shipping for the databases one by one just to see "how will it go".

    Is there maybe a way I could test/estimate/calculate this sort of thing before I actually go and implement it for 500 dbs.

    Any ideas/thoughts. Thanks