• Server 1 DB pubs is logshipped to server 2 db pub.

    Seperately, Server 1 db pubs replicates to server 2 db pubreadonly.

    Double the storage requirement but get the most out of your CPU and memory.

    Log shipping is for disaster recovery not for giving your users a database to run reports off of.

    John Zacharkan


    John Zacharkan