Because we have not had a good backup for a few days, I am trying to do a backup to disk right now, outside of the schedule. I want to create a new file, but I get an error message saying that my file is "not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. BACKUP DATABASE is terminating abnormally."
1. What is BACKUP WITH FORMAT?
2. Why won't it let me add a new file that is not part of the 'family' ?
3. How does it get to be part of the family?
I triggered an automatic backup by changing the scheduled time for backup, so I think I'm safe, but I would still like to know how to do a manual one.