Home Forums SQL Server 2008 SQL Server 2008 - General Doubt about Shrinking process , Rebiulding index and fragmenatation RE: Doubt about Shrinking process , Rebiulding index and fragmenatation

  • March 19, 2013 at 3:06 pm

    #1598646

    Lynn Pettis (3/19/2013)

    Erin Ramsay (3/19/2013)

    Why are you shrinking the log file? If your backup method is Full then the logfile will truncate on backup.

    Full and Differential backups do not truncate (mark VLFs as reusable) the t-log. Only transaction log backups accomplish this when a database is using the BULK_LOGGED or FULL recovery models.

    Learn something new every day...thank you, sir!