Post reply

First Tranlog backup after full backup very large

  • July 20, 2007 at 8:41 am

    #117950

    Could someone explain to me why after a full backup is completed and the first transaction log backup is done...it is the same size as the database itself?  Also, what can be done to adjust this?  Thanks.

  • July 20, 2007 at 8:47 am

    #721169

    I am assuming that there was significant work done prior to the full backup.  A full backup does not truncate the transaction log, that is only done by the transaction log backup.  During a full and differential backup, only enough of the transaction log is backed up to provide you with a consistant backup as of the end of the backup.

    BOL discusses this in pretty good detail.

  • July 20, 2007 at 9:46 am

    #721191

    It depends on the initial size of the log file that was created. Please follow this thread that discuss a similar issue to yours: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=140748

    Paul

  • July 23, 2007 at 4:37 am

    #721475

    The database was in full recovery mode. The data was initally loaded and backup taken the data that was loaded will be there in log file and hence both are of same size.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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