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, I love DR so I'm also intrigued as to what people think....

    Firstly, how big are the Db's on the server and secondly, do you have a budget to work with for your DR solution or do you have to 'price up' various scenarios first?

    If budget isn't an issue and the DB's aren't too big then I'd definitely look at mirroring with an automatic fail-over and witness server. If you're worried about overhead etc then maybe have a look at switching it to asynchronous mirroring (especially as you've indicated that the 'DR site can be a few hours old'). Depending on what transactions/usage your primary server gets and how that affects performance, you could also log ship to a 'warm standby' just to be on the safe side (overkill though maybe if mirroring is in place - depends how paranoid you are!! :-)).

    Do you have a testing environment that you can use, I'm not a huge fan of installing SQL Server on a virtual server but that might be one way of creating a viable test environment to check the impact of things like mirroring/log shipping on the sort of scale you're talking about.

    Do you have a plan with regard to backups etc?


    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