Hii....Please provide solution

  • Hiii,

    As i am new to SQL Server ,Can i know the what is the exact difference between the shrinking ,truncate and no_truncate

    Thanks & Regards,

    Kareem

  • In what sense? The word 'truncate' is used in more than one place with more than one meaning.

    If you're referring to the transaction log, please read through this - Managing Transaction Logs[/url], and post any specific questions you may have afterwards.

    If you're referring to something other than the transaction log, can you give some context and details to your question please.

    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 2 posts - 1 through 1 (of 1 total)

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