SQL Server Performance

logshipping problem

Discussion in 'SQL Server Log Shipping' started by chaitu1385, Dec 6, 2005.

  1. chaitu1385 New Member

    hi,
    i heard that TRUNCATE is non-logged operation.Now i have one doubt regarding this..

    Suppose during logshipping scheduled intervals if any one truncate the log file....then how the secondary server knows about this info? (I mean if the operation is non-logged then there is no LSN regarding to that backed up)

    any thoughts? (correct me if i am wrong in the above interpretation)

    krishna chaitanya.s
    project engineer-SQLDBA

    "To be confident of what u r accepting",I would say,"U have got to understand what u r rejecting."
  2. satya Moderator

  3. chaitu1385 New Member

    oh! my concept about truncate is wrong then.....

    Truncate is minimally logged.....not non-logged operation..


    thnx a lot satya

    krishna chaitanya.s
    project engineer-SQLDBA

    "To be confident of what u r accepting",I would say,"U have got to understand what u r rejecting."

Share This Page