Have I pushed him away???

I am in a long term relationship and have a two year old I have been wanting another baby, but every time I bring it up he says no . Iv been getting very upset about it which leads it to rows.

He has now turned around and said he doesn't want any more children and he doesn't want to be with me either that Iv ruined things with my constant nagging.

All I wanted is to know if he wanted more,

deep down I knew he did but wanted him to tell me. We are now sleeping in separate rooms only since tonight.

Have I thrown away an 8 year relationship?? I love him with all my heart and hate the thought that Iv ruined my family?

Any advice would be helpful