Post reply

Full recovery model

  • October 13, 2010 at 3:58 am

    #142236

    Will a 'truncate' happens in a full recover model database.

  • October 13, 2010 at 4:03 am

    #1236057

    Please clarify your question.

    Truncate what? (There are three places at least where that term is used in SQL)

    Under what circumstances are you asking. Technically anything can happen if someone runs the command to cause it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2010 at 4:05 am

    #1236058

    i mean to say ..if a 'truncate' command happened in a database.Will it be logged in a full recovery model

  • October 13, 2010 at 4:10 am

    #1236061

    Are you talking about TRUNCATE TABLE?

    As i mentioned, there are three different concepts that truncate refers to, please be specific.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2010 at 4:25 am

    #1236064

    yes truncate table

  • October 13, 2010 at 4:50 am

    #1236072

    Truncate table is logged in all recovery models. There's no such thing as an unlogged data modification in SQL Server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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