I am planning to implement logshipping between Prod and DR servers. I heard that we should not use the truncate command on a DB which is using logshipping,Is it True? Will it break logshipping. [I have tested logshipping by truncating the table, and i see the table is truncated on the secondary DB and logshipping is running smooth.] What are the things that I shouldn't do while a DB is logshipping.
I haven't experienced any issues with truncating tables with log shipping, however if you truncate your transaction log you will break log shipping. Quite possibly that is what someone else was warning you against.
Truncating table will not effect on logshipping database, it will propapages the changes to secondary. Truncate command is a minimally logged command which notes in the transactional log about dellocated data pages for that perticular table and the same will be shipped to secondary so you can perform traction of table. But trucation of log will breaks up the logshipping you need to reinitialize the secondary.