• GilaMonster (2/15/2013)


    jblovesthegym (4/18/2012)


    SOME POSTS in this thread are indeed over two years old, but the one immediately preceding yours answers a lot of questions I was going to pose (as I am looking after log shipping of over 50 dbs on SS2K) on the forum.

    Worth noting that the info given in the post you mention is lacking a few very critical points.

    Maybe take a read through this before you go off and use bulk logged recovery. It does have some downsides, it's not always interchangeable with full recovery (eg when there's mirroring), there are some risks to running it and it won't reduce the size of your log backups.

    http://www.sqlservercentral.com/articles/Recovery+Model/89664/

    You are right Gail. Indeed, I should have added in my post that using the bulk logged recovery model will not reduce the size of log backups. It will only protect the transaction log files from growing very large without breaking the log chain.


    Sujeet Singh