For reporting purpose, I am planning to setup log-shipping on our production database to reporting database. But one of the maintenance what I do on our production database is - truncate the txn log on the weekend and take a full backup immediately. Since I am going to setup log-shipping, I was wondering, will this truncate affect the log-shipping process?
Appreciate any suggestions.
Thanks,
Cali