@Northwinds
But I've tried to set some boundaries and said he should try and not go out every weekend.
You don't set boundaries for other people, they get to set their own whether we like it or not. It's only up to you to decide whether or not want to accept the boundaries they set for themselves. But actually, in a healthy relationship one partner considers the other before 'acting'. When that happens, boundaries per se don't really need to be set.
Thing is he can't control his drinking, so if he does go out, on, say, a Friday night, if I leave him to it, he will sleep in til noon and then be a bit of a slob/hungover all day, sleeping on the sofa at times and just generally not being available much to parent or spend quality time with the kids.
So, he's an alcoholic. An alcoholic isn't just the bum on Skid Row drinking cheap hooch from a brown paper bag. An alcoholic is someone who cannot control their drinking, period. Whether it's going on benders every night or a bender once in a blue moon, it's still the inability to stop once they've started. I suggest you contact your local chapter of Al-Anon. You may find it helpful and informative.
FWIW, I don't think these 'resets' will do any good. He is who he is and you are who you are. If you have to keep 'resetting' something, then chances are it's not that good in the first place. I mean, if I had a clock that kept losing or gaining time, I wouldn't keep 'resetting' it. I'd get a new clock! Not that I'm proposing you find a new husband, just to decide whether the one you have that you have to 'reset' is worth keeping.
Listen, my marriage (35+ years) hasn't been a complete bed of roses. DH and I have certainly had our 'moments', especially when our children were young. But we've never had to 'reset' our relationship. We've apologized for our actions, forgiven each other, picked up from where we left off, and continued down our road.