logshipping problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

logshipping problem

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."

Review Frank’s and my reference in thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11469 thread about your doubt. HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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."

]]>