Why puppies need night-time breaks at all
Bladder capacity in a young puppy is genuinely limited by age, roughly one hour of holding per month of age as a rough guide, capping out around 8-9 hours once fully grown. An 8-10 week old puppy simply cannot hold it for a typical 7-8 hour night, no matter how consistent the daytime training is. Planning for at least one night wake-up in the early weeks is realistic, not a sign something is going wrong.
Setting up the schedule
For very young puppies, a wake-up roughly 4-5 hours after the last outside trip before bed is a reasonable starting point, adjusted based on how they actually cope. As they approach 4-5 months and their bladder matures, most puppies can start stretching to a full night, and the wake-up trip can be dropped gradually rather than all at once. Watch for whining or restlessness as the cue that a trip is needed rather than sticking rigidly to a clock if your puppy's pattern differs.
Keeping night trips low-key
The goal of a night trip is toileting only, not play or attention. Keep lights dim, skip any excited greeting or games, take your puppy straight to the usual spot, and bring them straight back to bed once they've finished. If night trips become fun (light, voices, play), a puppy can start waking up on purpose for the attention rather than a genuine need, which undoes the routine you're trying to build.
Managing the last trip before bed
Give the final outside trip as close to actual bedtime as possible, and hold water back for roughly the last hour or two before bed (food a little earlier still) so the puppy isn't going to sleep with a full bladder. This alone often reduces how early the night wake-up is needed.
When to expect night breaks to end
Most puppies can comfortably sleep through the night without a break somewhere between 4 and 6 months old, though smaller breeds sometimes take a little longer given their smaller bladder capacity. If a puppy is well past that age and still reliably needing a night trip, or if accidents start happening overnight in a puppy who was previously sleeping through, it's worth a vet check, since a urinary issue can present as sudden overnight accidents rather than a training gap.