Post reply

Does a full database backup have same effects as TLOG backup on the log?

  • February 11, 2008 at 5:08 am

    #122019

    Hello, dumb question here ... but when you do a TLOG backup, it backs up all committed data in the log and removes it correct? Do you achieve similar results in a database backup?

    Thanks

  • February 11, 2008 at 2:15 pm

    #777081

    Not quite. A full backup will backup the database and enough of the log to recover the database when it is restored, but it will not truncate the log. So if you are running a database in FULL or BULK_LOGGED recovery, the transaction log will continue to grow if you are only doing full backups.

    See this topic in BOL 2005:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/4d933d19-8d21-4aa1-8153-d230cb3a3f99.htm


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

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

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