Post reply

Backup

  • May 4, 2008 at 9:38 pm

    #121355

    Hi

    I want to know about full backup of database.whether it takes the T Log backup fully.Can we truncate t logs in full bkp .pls explain

    Binu

  • May 4, 2008 at 9:50 pm

    #810506

    Hello Binu,

    A full backup will not truncate the log instead you need to take a transaction log backup which will truncate the log.

    [font="Verdana"]- Deepak[/font]

  • May 5, 2008 at 5:08 am

    #810580

    If your database is not production and would like to truncate tlog frequently you can set the database to the simple recovery mode. If your database is production than tlog backup is recomended for point in time recovery.

    Full Backup and Tlog backup are two different thing. Do not confuse or mixed with each other.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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