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?
October 26, 2009 2:53 PM
October 27, 2009 3:41 AM