Post reply

DB Mirroring and Replication or Log Shipping

  • May 15, 2008 at 9:53 am

    #190536

    I have a client who is currently using SQL Server 2005 DB Mirroring and they would like to have a copy of this database on a third server to offload querying to. We are currently looking into using either Replication or Log Shipping to accomplish this. Would either solution be recommended over the other to work alongside db mirroring?

  • May 19, 2008 at 9:44 am

    #817278

    Understand that with log shipping you'll have to kick everyone out of the DB to apply the logs, which is fine if you're only going to ship them once a day, but if you want it to fairly transactionally consistent, then it won't work for a read DB at all. In this case, repl is your only option.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 20, 2008 at 2:52 pm

    #818239

    I am currently looking at this myself for a proposal paper for a client's client.

    If I understand you correctly - your client is using mirroring to replicate to a second box and would like a copy of this replicated database in order to do report on?

    If this is the case then you could consider using the snapshot facility.

    have a read of this article and it might give you some ideas

    http://www.sqlservercentral.com/articles/Reporting+System/61688/

    hth

    john

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply