I am using SQL 2005 Express and using SQLCMD utility to back up my database and transaction logs. Here is my backup schedule..
Transaction Log backup starts at 12:30 am everyday, and run for every hour that means I have the log backup like at 12:30am, 1:30 am, 2:30 am,... 8:30pm, 9:30pm...
My full database backup starts at 9pm every night.
I want to know, if I restore my 9pm full backup and using the 9:30pm transactions log backup to restore it, so in this scenario, would 9:30pm transaction log includes those logs after 8:30pm? And because my full backup is run at 9pm, then it should include all entries between 8:30pm to 9pm already, if the 9:30pm log restored, any duplicated record?