I'm struggling with when is the right time to do my last transactional log backup before my full database backup.
My question is this:
if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm).
If i have to restore the db to a point in time, say 11pm. I would use the 12pm backup. But that backup overlaps the time i ran the full db backup. Does this even matter? Or will I have duplicate transactions because the transactions are already in the db and will be applied again when i restore the log file?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!