Relationship disaster

I have been with my partner for nine years and I love her so much. We have been each other’s rock through every year. When we first got together I said to her time and time again I have had the snip I won’t be able to give u children. Which every reply was I know it’s all good. Well nine years on she wants children. She has started drinking more. We have been arguing more. I don’t know what to do. I love her so much I don’t want to loose her but I want her to be happy too. she can have what every woman wants a baby. Which will make her happy so is it best to let her go. It’s so heart braking. Help please.

What about IVF or adoption?