It depends on how you've configured SQL Server. It can pare off the older backups from the file while adding new backups on. Much like it does with individual files,...

I never really understood (unless I try to disconnect reality and travel back in time to the days when SQL was created and tape drives were directly attached to the...