• ashish.kuriyal (2/13/2010)


    What is important is your log backup must be at regular frequency as per your database size

    Frequency of log backups is not related to DB size. It's related to DB activity and the maximum amount of data that the business is willing to lose in a disaster.

    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