Post reply

Full vs Bulk logged recovery models

  • April 12, 2011 at 4:14 am

    #143795

    Have two server of the same configuration and the database in this case is also of same size (log file). Inserted 30 million records to each servers. Server A is in full recovery mode and B is in bulk-logged. After insertion took log backup of both and server A which is in full recovery mode completed the log backup in 30mins where are then one in bulk logged took 3 hours .

    Can anyone please explain why?

    TIA

  • April 12, 2011 at 4:24 am

    #1310280

    http://msdn.microsoft.com/en-us/library/ms190692.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 12, 2011 at 10:54 pm

    #1310796

    GilaMonster (4/12/2011)

    http://msdn.microsoft.com/en-us/library/ms190692.aspx

    Thanks Gail.

    I hope the answer for my question is that the log backup contains informationjs from that modified extents also where as in full recovery model everything will be there in transaction log itself and taking the log backup will take only the informations in transaction log.

    Please correct me if am wrong..

    Thanks a ton.

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

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