A full nights sleep will happen again, I promise! As your puppy gets older, he'll be able to hold it longer and longer. My 10 week old has been needing to go every 3-4 hours during the night. Last night, though, we went to bed about midnight and didn't wake us up until 6 this morning! Yay!
Also, make sure he potties right before bed and limit food and water right before bed if hypoglycemia isn't a risk. Hope this helps!