Did anyone have a lot of misses in the beginning and still successfully pottytrain?

I just watched a video that said the key to successful potty training is NEVER allowing them to go in the house. Checks out. I’ve had my golden retriever pup on a leash inside and watch him most of the day and catch most of the pees and poos now (he’s 9 weeks Old)

Only…. It’s the night time I’m struggling with. I’m sleep deprived. I limit water 2hrs before bed. I only give him dinner around supper time. I take him out at 10pm and set two alarms – one for 2am and one for 6am.

But still, every morningn / night there’s pee on the floor. When I wake up and see it I always, always take him outside and praise him for going outside.

I know his bladder is still small – but realistically I can’t be awake all night every night to watch him. I’m not sure if crate training would help (though we are going to get one) as he’s actually peed in our bed before –

I’m asking – anyone here have a pup who peed on the floor in the night and as they got older were able to “hold it” and figure it out? I’m soooo worried I’m going to have a bad habit started here but I’m SO TIRED 😪