How did you pick a middle name?

We gave our first daughter a family name for her middle name, but we’re struggling to pick a middle name for this baby girl. My husband wants to use a random name that he likes with no meaning behind it. I’ve always thought most people used a family name or a meaningful name, but I’m open to it. Would it be weird to just choose a random name without any real meaning other than it sounds nice?