Post reply

Log Backup size bigger than Full Backup

  • November 10, 2014 at 3:30 am

    #312393

    Hi,

    I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files are huge in size when comparing with Full Backup. I took Full backup with compression. Is there any way to bring down the log backup size.

    Thanks in Advance.

  • November 10, 2014 at 3:41 am

    #1757380

    yes, run more frequent log backups!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 10, 2014 at 7:34 am

    #1757429

    haichells (11/10/2014)

    Hi,

    I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files are huge in size when comparing with Full Backup. I took Full backup with compression. Is there any way to bring down the log backup size.

    Thanks in Advance.

    Because your log backups are only once a day, you stand a chance of losing a whole day's worth of work. For most production systems, I recommend no more than an hour between PIT log file backups. If you have the disk space, I also recommend taking a full backup every night and always keeping the latest 2 ready on disk along with all of their log file backups.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • November 10, 2014 at 9:43 am

    #1757474

    haichells (11/10/2014)

    Hi,

    I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files are huge in size when comparing with Full Backup. I took Full backup with compression. Is there any way to bring down the log backup size.

    Thanks in Advance.

    What are the disaster recovery requirements for this database ??

  • November 11, 2014 at 2:48 am

    #1757629

    Don't have any disaster recovery process for this instance...

  • November 12, 2014 at 2:23 am

    #1757851

    Can anyone guide me on the checkpoint command. Issuing a checkpoint and shrinking the log file will help to reduce the log file backup size???

Viewing 6 posts - 1 through 5 (of 5 total)

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