smallmoney (8/20/2012)
I truncated a table in my mirrored training environment on Principle side.From what I remembered, TRUNCATE TABLE [tablename] is not a logged opereation.
Will this cause problems on the Mirror side?
Thanks!
It is minimally logged operation but wrong to say that it is unlogged. Information is logged therefore it can even be rolled back if done inside a transaction where commit was no issued and a rollback was initiated due to some reason.
Chandan