In simple terms, I need point-in-time restore between full backups - what are the consequences in the following plan - the database is in full recovery mode:
- 1:00 AM Transaction Log Backup (no Truncation or Shrinking)
- 1:30 AM Full Backup
- 2:00 AM Transaction Log Backup (Truncate and Shrink)
- Then every 30 Minutes Transaction Log Backup (no Truncation or Shrinking)
Will this provide me with the ability to point-in-time restore the database at any point except for the time between 1:30am and 2am?