SQL Server backup media set and file separation If I am going to do such a backup plan under full recovery model for a particular database
- Weekly full database backup
- Daily differential backup
- hourly T-log backup
Retention period: 28 days
How should I arrange the files? Should each and every backup have a unique file name?
I tried using SMSS to do a few and ending up all backups in a single test.bak file. I can see the content of the backup file test.bak contains a lot of backups including full backups, differential backups and log backups.
I know it wasn't right. What is the best practice for arranging backups into separate physical backup files?