• This is also true of FULL backups and LOG backups. If you append them, rather than overwrite, you have to know the proper file number to restore. Otherwise, you restore the first file. That's in the BOL under RESTORE.

    So, it's a good article, but you make it sound like this only occurs with DIFFERENTIAL backups, when it happens for ANY type of backup that is appended.

    -SQLBill