You would think that it would be easy to find this information but I guess my googling skills are rusty. I've never had to run a recovery from a t-logs (which is a good thing), and apart from it being good to know, I need some info regarding Transaction Logs. I am working on a DR plan and we need to run log shipping to the DR server. Unfortunately, we are stuck with SQL Server Standard, so I settled on log-shipping as the technique to move data. My question is regarding to what is stored in the T-Log. I know inserts, updates, and deletes are stored but I also wanted to ask about new stored procs, functions, views, roles, logins, password changes, etc. Are all of these stored in the T-Logs as well? I need this information because if any of these are not, I'm going to have to do updates to both the DR site and the production site at the same time.