Excited. . . But scared

So I just scheduled my first ultrasound and I'm sooooooo excited it's finally hitting me that this is happening, but I'm terrified because it's transvaginal. I've seen a lot of ladies on here say they had red spotting after a transvaginal ultrasound and I'm scared. I even ready someone had a miscarriage after one. Can you all please share your experiences with me I need my good thoughts to outway the bad lol. Can't wait to see my little chocolate chip I'll be 7 weeks 😊 that day.