Thanks for the reply. Just from backup and recovery stand point, both setup will do the same, right?
No as diffs don't give you point-in-time recovery, only tlog backups give that. Plus you're going to have a lot more storage needs with hourly diffs. Do diffs maybe 12 hours after the full backup or daily diffs and weekly fulls.
Here's our setup: 1. Nightly full backup at 2am 2. Diff at 2pm 3. Tlog backups every 15 minutes
Please proceed with second method because Tlog backup is used to point in restore for Full Recovery model to database .This Tlog back will take the more storage but keep the Tlog within the minimum interval as per your requirement.